Recent Topics
document outline break down
this line break down document outline dbforge for oracle 6.0.85
"Go to definition" jumps to the package specification, not the package body, like a shift+F12
Hi. Thank you for last update DBForge studio for Oracle to 6.0.85. Great job. Fixed many bugs. But at the same time a new problem appeared - "Go to definition" (F12) makes jump to package spec. (like a shift+F12) rather then to package body, . Reloading
Prevent ODAC from appearing in Delphi main menu
Hello, After I install ODAC components into Delphi, "ODAC" is inserted into Delphi's main menu. Is there a way to prevent (or remove) this? Thanks John Dorlon
Delphi 12.3 64bit-IDE support
Hi when can we expect the design-time controls for the 64bit IDE of Delphi 12.3 for the Delphi Data components ? Kind regards, Erik
ORA-00918: column ambiguously defined for paging mode (
hi, i got error while getting next page of query result. for first page i have warning - it's Ok. but for next page i have ERROR 1 ORA-00918: column ambiguously defined SQL3.sql 3 8 Yes, i really have repeating column names, but without paging or for
header of tab sometimes not in visible position !!!
Hi, sometimes the tab header is not in visible position after opening new tab and need to scroll tabs for finding it.
'relation "__EFMigrationsHistory" already exists' when running multiple migration sets
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.
[PgDAC] Error when executing SQL Query in table with blob files
Hi there, hope you'll ok. I recently started using PgDAC for queries that works with blob files, especially using the "execute" command of PostgreSQL (version 16). When i execute the query, i'm getting the following error: "ERROR: Assertion failure (D:\Jenkins\workspace\DAC\PgDAC\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas,
New BOOLEAN datatype not supported with Oracle 23ai client
Hello, I am using the latest version of ODAC and Delphi. When I connect to an Oracle 23ai database, using an Oracle 23ai client, and I select (using TSmartQuery) from a table that has a column of datatype BOOLEAN (for example: Select * from user_domain_cols),
TScFTPClient 'FTP server error occurred: TLS required, configure with AUTH first.'
Get the EScFTPError 'FTP server error occurred: TLS required, configure with AUTH first' FFtpClient.TLSMode := tmRequireExplicitTLS FFtpClient.SSLOptions.IgnoreServerCertificateConstraints := true; FFtpClient.SSLOptions.IgnoreServerCertificateInsecurity
Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)
I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.
SQL Complete No Longer Shows Column List For Trigger Tables
I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members CREATE TRIGGER [dbo].[tu_Contact_StandingId] ON [dbo].[Contact] AFTER UPDATE AS BEGIN IF UPDATE(StandingId) BEGIN INSERT CapitaTransaction
TScSMTPClient for dummies
Hi, I am playing a little around with ScSMTPClient and was able to send mails. I am currently failing to get/receive an errror when using an non existing adress no matter wether used as a from or to address. Am I right that this is probably related to
SQL Complete Execution History Import
Is there a way to move over query execution history from one computer to another?
Any plans to create an ODBC driver for Xero?
Hi Just wondering if there is any plans in the works to create an ODBC driver for the Xero platform?
.NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include
Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)
Memory leak in SecureBridge
Hi, Securebridge initialization code as allocates object which is newer release causing memory leak. I know that it's not dangerous, cause it doesn't repeat but I was just wondering could the code be fixed so that while catching memory leaks, I wouldn't
.NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.
Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using
Invalid command line. Unknown switch 'connection:user'.
I've been using dbforgemysql in Windows for manual backups and decided to automate it after a recent server crash at our ISP. I've followed the directions, but no matter what I do I receive an error. Invalid command line. Unknown switch 'connection:user'.
SecureBridge Installer won't let me uncheck any components
Hello, I want to uncheck the following in the SecureBridge installer, but the boxes don't respond when I uncheck them. SecureBridge files for Win64 (Modern) SecureBridge files for macOS SecureBridge files for Android It's not a big deal, just annoying.
ERROR: FUNCTION 'SESSIONPROPERTY' is not supported.
Hi, Anyone had this error when trying to conect do a Microsoft Fabric instance? The endpoints works fina on Azure Data Studio and SSMS but i get this error on DBFORGE Studio for SQL Server
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
SDAC older versions download
Hello, Where can I download older versions of SDAC? I have UniDAC installed on our developer machine and it says I need very specific version of SDAC, not any two versions are compatible. So, I need to try SDAC on Delphi 11 Alexandria, specifically version
C++ Builder error: E2015 Ambiguity between 'Crjson::TJSONObject' and 'System::Json::TJSONObject'
I just moved one of my C++ Builder projects to RAD Studio 12.2 and UniDAC 10.3.2. I am getting the above error plus E2015 Ambiguity between 'Crjson::TJSONArray' and 'System::Json::TJSONArray'. I am only using TJSONObject and TJSONArray in this project,
How to quickly find DB Connections
Does anyone have any solutions for how to quickly find DB connections in Database Explorer when you work for a large company and have thousands of connections for all different servers? There isn't even a search bar and it would take forever to manually
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
SQLite low-level
i want to understand - can i use unidac/litedac in low-level mode? without connections, datasets and so on. as i see - a can use LiteStaticUni module. and, may be, some thing else. is there are some description or manuals for it?
TUniQuery fails with Parameterized UpdateSQL while updating data in AWS to Bablefish for Aurora PostgresSQL
Hi We have been using your wonderful library of UniDAC components (for SQL Server) for several years now and currently use version 10.1.0 professional version for Delphi 12. Currently we were evaluating to move our database to AWS through Bablefish implementation
Secure bridge sign PDF
hello i need help about signing some PDF file, with secure bridge... Some examples, sign with PFX or from smart card...
Define ClientID and ClientSecret in Dynamics365 ODBC DSN
Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app
Schema Compare for Postgresql: Triggers comparison
Hello Where can I find an exhaustive list of what schema objects are currently supported and not supported when doing a schema comparison using dbForge for PostgreSQL? I was under the impression triggers are supported by this does not seem to be the
Oracle Idle Time and Odac
I am running Odac 12.1.1 with Oracle as my database. In Oracle, the idle time is set to 1 min. SQLPlus disconnects perfectly after 1 min idle time. My frontend application however exactly disconnects after 3 min Why is that ? Anyone else seen such behaviour
Why no feature to convert T-SQL to LINQ for .NET 9 Core?
I keep requesting and keep hoping my yearly subscription will get T-SQL to LINQ for .NET 9 core. But sadly every year passes an no feature added? Stored Procedures are a thing of the past and most development projects no longer use them. It's 2025, can't
Documentation tool doesn't generate flow diagrams for Stored Procedures?
I'm puzzled that such an important feature for those of us converting legacy databases to a more modern architecture don't have any tools that can flow diagram T-SQL stored procedures? I feel like your products are dancing around "real world" developer
VirtualQuery IsNULL
Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE
SqLite Localized Order
Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception
Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",
Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)
Cannot find Datamodel.hbml file error NHibernate
I am following the instructions for database first creation. However, at the end, the template fails to find the hbml file in the appdata folders. This only happens with NHibernate templates.
Next Page