[bug] auto-where by RefreshRecord
After update from 7.0.1 to 7.4.0 started misidentifying where-statement and by RefreshRecord joins WHERE once more, instead of an additions! PgQuery.KeyFields := 'r_id';
TUntQuery Is there an asynchronous loading parameter？
TADOQUERY.ExecuteOptions := [eoAsyncFetch]; // Asynchronous Read ，Do not block UI. TUniQuery，Do have similar parameters? Env：Windows+Delphi11.3
Syncing an Oracle 11g with Partitioning
Hello, i'm trying to sync an Oracle 11g with Partitioning. The Provisioning works for a while (a few minutes) then throws an Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user
MySQL ODBC Driver SSH Connection with keys
I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work. I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password.
Delphi closes upon opening project SDAC problem.
Hi i have a problem when i open a project that uses SDAC on Delphi 11.3 it automatically closes the IDE without any error. It clearly happens the moment it try's to access the SQL server as the SQL wait icon is then on screen. After about 10 seconds the
"Lost connection to mysql server during query" when Fetchall:=False
A year ago I posted a similar question on the old forum. Now I think I can reproduce the error with a simple program. I add a master and a detail table. When I set Fetchall to TRUE everything works fine when I delete the master row. If I switch to Fetchall:=FALSE
TUniMetadata and database structure.
Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;
Release notes on new Delphi Data Components
Hi, first all let me say the new forum is nearly unusable. It might look modern, but it's horrid. There are new updates for all the Delphi Database Components, however nowhere can the release notes be found. Can you supply them ? (They used to be available
UniDac 9.4.0 cannot connect to SQL Server
I have been using UniDac for years and I routinely connect to Firebird 3 and SQL Server databases (often at the same time). I just updated from UniDac 9.3.0. to 9.4.0. Now I cannot connect to the same SQL Server databases I have been connecting to for
Delphi SQL Database Access Components 10.3
Hi, We just updated to the new release, rolled out a new version to a client but the Tconnection will not connect on the SQL 2022 Express DB if i roll back to the version prior to this release it works fine, which we have had to do in this circumsta
Oracle Database Sync Is Very Slow Then Throw An Exception
Hallo, i'm using dotConnect for Oracle and dotConnect for SQLite to sync an huge Oracle database with an SQLite database using a windows service. By starting the windows service started the sync process. The Oracle 19c server and the windows service are
Problems with mapping types to ATTACHed SQLite databases (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0)
Hello. I've created a simple project (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0) with 3-level entities: public class UserRole { public Int64 Id { get; set; } public String Name { get; set; } public virtual IList<User> Users { get; set; } } public
Unidac Mysql Cache DNS
When the IP of a web address changes Unidac is looking for the previous IP. I am connecting Unidac with mysql via address mysql.kinghost.com When Kinghost changes the server's IP, Unidac continues to look for the previous IP address that is no longer
TOP N query to Salesforce returning all records
Any ideas why the single table select query with TOP N would return ALL rows, while using a join (second query below) will limit to 100 returned rows? SELECT Top 100 c.Name, c.Email FROM [SALESFORCE]...Contact c SELECT Top 100 c.Name, c.Email, a.Name
ODBC driver conenction to excel power query. Access to REST API is restricted by iTheme Security settings
HI, any help with this please?
Firebird Get Identity field after a Post
I know you can use as Returning to get the Identity field when using an insert SQL. But I need to do it with a SELECT statement and an insert; eg uniquery.close; uniquery.options.RequiredFields := false; //because of Identity field uniquery.sql.clear;
Timestamp With Time Zone Field not TSQLTimeStampOffsetField?
Hi, Is there any reason why the implementation of your TIBCTimeStampTZField is not based on the built in TSQLTimeStampOffsetField? There's no documentation on the TIBCTimeStampTZField either. With regards, Martijn
Salesforce ODBC SQL Server linked server not able to browse catalogs/tables in SSMS, but can query them
I'm not sure we have our linked server security setup correctly - our Salesforce user seems to be working correctly as we can query data from various tables, but our SQL Server linked server (using Salesforce ODBC driver) is not allowing us to browse
Does SSIS Data Flow supported in SQL 2022?
I get the following error in SQL 2022，any help would be appreciated:
Built-in Oracle spatial functions for EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. Previously in LINQ queries we frequently used spatial functions which were nicely translated to SQL, such as Devart.Data.Oracle.Entity.OracleSpatialFunctions.SdoRelate(geometry1,
InterBase Data Access Components 8.3.0 / Delphi XE8, Exe-File corrupted
- Download InterBase Data Access Components 8.3.0 for Delphi XE8 - File cannot be started - Error Message "The source file is corrupted"
TUniQuery - Prepare and IsQuery on PostgreSQL
Hello. Does Prepare and IsQuery methods (of Query) work on PostgreSQL database? I'm using Unidac 9.3.0 on Delphi 11.1 Alexandria. Simple code like the one I've posted, works on Firebird, Oracle, MSSql server, but not working in PostgreSQL (PG version
Query/Table SavetoXML with large datasets
First, let me say this forum looks awful. Anyway, I am using uniTable.SavetoXML(name of file) and it is generally working fine - on small tables. With large tables I get an 'Out of memory' error. the system seems to be loading the whole table into memory
SProcs using ODBC for QurickBooks
I'm trying to execute a sproc via a trigger to create a record in QuickBooks.... I'm getting "OLE DB provider "MSDASQL" for linked server "BT_QB" returned message "[Devart][ODBC]Optional feature not implemented". Doesn't the ODBC drivers for QuickBooks
In Version 6.0.3 is impossible to run transaction RO
Dears according to information provided by you I am starting read-only transactions by this command KPTrans = KPSessionName->BeginTransaction(5); It works perfectly till version 6.0.2, but the last version 6.0.3 doesnt work, and stay in RW transaction.
connectionstring, connnection properties and localdb
Hello, have con.ConnectString:='Provider=SQLNCLI11.1;Integrated Security=SSPI;Initial Catalog=somedatabase;Data Source=(localdb)\mssqllocaldb'; this works correctly. When i want to set this values as properties of object con (TMSConnection), i did not
Delphi 11.2, AnyDac 9.3.0, ReportBuilder 22.0
Hi. Trying to compiler rbUniDAC.dpk using Delphi 11.2 / AnyDac 9.3.0 / ReportBuilder 22.0 got the error message below: [dcc32 Fatal Error] daUniDAC.pas(21): E2411 Unit ppPDFDigitalSignatureDlg in package rbRCL2228 refers to unit Vcl.CustomizeDlg which
DBGrid Postgres
Hi, I've a problem to show some string in DBGrid Column number 3 si not show I have (MEMO) instead. My query : RequeteRapportAEnvoyer.Sql.Text := 'SELECT A.IN_TYPE,A.S_ID,A.IN_ID,A.IN_DATE,CAST(TRIM(CONCAT(CONCAT(B.T_PRENOM,'' ''),B.T_NOM)) AS VARCHAR(100))
firebird 4
from what version can i connect firebird 4 i have the version 4.2.3 wil wok
Firebird 4
from what version can i connect to firebird 4
User defined functions in Entity Framework Core 7.0
Hello. I'm porting my code from "classic" Entity Framework 6.4 to Entity Framework Core 7.0. What is replacement for the following code (User defined functions setup)? Most classes doesn't exist in both Devart.Data.SQLite and Microsoft.EntityFrameworkCore
Assert error in UNIDAC
Hi Connecting to postgres through UNIDAC. Query is taken from DB monitor. Insert to same table with same fields works fine. query : update eeli_1.t1009_packages("t1009_id","fd","td","t1002_id","t0106_id","package_name","start_sn","stop_sn","bar_code","user_id","in_date","comments","unit_name","s_id","pd_id","del_user_id","del_in_date","min_unit_name","code","min_unit_count")
.Net 7 support
Do dotConnect for Oracle support .Net 7? If not when will you will support it? Thanks.
Devart.Data.MySql & .NET 7 support
Hello, .NET 7 is out and we would like to upgrade our projects. Unfortunately the Devart.Data.MySql.EFCore package seems to not be compatible with it. Do you plan to have a compatible version any time soon ? Regards
SLOW START DELPHI APPLICATION
Hello, My Delphi Embarcadero application uses TUniQuery, to access 2 Interbase Tables, and TUniTable to access 2 DBF Tables. The application is getting slower and slower and slower when starts, more than 2 minutes. Every day is slower than the day before.
PostgreSQL 15.x support
Does anybody use the current version with the latest PostgreSQL 15.x versions? I'm still using 13.x and I have to migrate a server. So I just want to be sure, if there may be any issues UniDAC - PostgreSQL 15.x? When will there be a release with offical
Firebird ODBC driver can't open table using with BDE on Delphi11.2
When open database I tested Firebird ODBC driver using with BDE on Delphi11.2. I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8." I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator
BigQuery ODBC driver | Data truncation
Hello, My company has recently purchased and installed the ODBC Driver for Google BigQuery. We are pushing data from BigQuery into a SQL Server database. It is working well for small datasets, however when we try to query for large datasets (e.g. 2 million
The new forum is awful and totally unreadable.
Hello, The new forum is totally unreadable. - posts are mixed between components, - number of post about UniDac since the new forum started seems to no showing all posts (only few posts) , - the topics are not organized i table (ie no columns for viewers,
Deployment issue, System.TypeLoadException
We recently updated our web application from dotConnect for MySQL 8.17 to 9.0.0 (with EF5). Everything works fine on dev machines but not when deployed to the web server (Windows Server 2012): System.Data.EntityCommandCompilationException: An error occurred
Next Page