I'd like to ask you to cancel my subscription
Hello. The automatic renewal was checked at the time of purchase last year, so the product that was not scheduled to be used this year was automatically paid. I'd like to cancel my subscription, can I know how?
Unidac 9.3.0, Delphi XE2 ver 16.04, Oracle EE with TDE, ORA-00600
Hello, I am using UniDac version 9.3.0 with Delphi XE2 Version 16.0.4504.48759 on an oracle database 19c Enterprise Edition with TDE configured. I have a table with two columns crypted. Here the script I've used: ALTER TABLE utenti MODIFY (USERNAME ENCRYPT
Cancel Subscription
I'd like to cancel my annual subscription for MySQL Database COmponents. Where can I do this?
Как правильно работать c компонент Encryption Unidac Firebird3?
Добрый день Подскажите пожалуйста как правильно работать c компонент Encryption Unidac Firebird3? то что работал Ibdac перестал работать Unidac База Firebird 3 тип поля VARCHAR(2000) CHARACTER SET OCTETS COLLATE OCTETS В Ibdac работает но в Unidac после
IndexFieldNames
Hi, I need "natural sort" as a sorting algorithm to use with IndexFieldNames. For natural sort see: https://en.wikipedia.org/wiki/Natural_sort_order I have an article number field as varchar. Some of my customers have article numbers with mixed letters
Automatic Timestamp Macro
Hi, I found this topic and I think this is still a problem with UniDac: https://forums.devart.com/viewtopic.php?f=28&t=38112 When I use an SQL like ".... {timestamp '......'] ..." this works fine except for one client where I get an error: La conversion
How to translate SQLite messages
Hi, I use UniDAC to deal with SQLite databases. I use direct mode. If there is any error I use EUniError(E).ErrorCode but it is not detailed. (usually returns 1). E.Message holds detailed message in English. How to intercept to be able to get real error
Best practice to work with SQL Server transactions
Hello, what's the best way to perform a transaction with a TMSQuery? See the following source code: try LQuery := LDatenHandler.GetQuery; // returns an TMSQuery object try LQuery.SQL.Clear; LQuery.SQL.Add('Begin transaction'); LQuery.SQL.Add('INSERT INTO
Insert to oracle 21 -> -922337203685478 value instead of 1.99 (exactly 1,99)
Hello, we have a problem with entering values to fields. The value 1.99 is entered into the table as null or as -922337203685478. We are using a 32 bit client - there is a problem on it. On the 64 client it is fine, unfortunately we cannot use it. Current
Performance on PostgreSQL connection
Good afternoon! We use TUniConnection in our applications, using in most cases the PostgreSQL database. We are experiencing problems related to slowness, especially when our customers use VPN for the connection. We are currently using the parameters below:
EMyError
Hey there, I think that the online documentation for EMyError is *very* incomplete. There is no mention, for example, of a "Message" property, which I've seen you mention in some help topics. Can you please point me where I can find the structure of EMyError
NET:IOHandler is not specified
A user is receiving this error message when attempting to connect to the database using a TOraSession in DIRECT mode. Can you tell me what this error means and how to resolve it? I am using the most recent ODAC version on Delphi 11.3 compiling in 64 bit.
Modify TStringField for ANSI / UTF translation
I am using the latest UniDac version with Delphi 12.3 on an oracle database (db2 / sqlserver planned) There are many old cobol applications running which not support UniCode, so data is written as AnsiString using the codepage setting of the windows client.
UniDac - Delphi 11.3 - OpenSSL - Linux
Hello Community, We'd like to upgrade our Ubuntu Docker containers from V 18.04 to someting newer. We'd also like to use newer SSL components, but it seems like UniDac (MySqlConnector) only works with OpenSSL 1.x.x. Can someone shed some light on that
'Invalid parameter specified' on prepared query with a double
In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third
ConnectDialog
Hello, when trying to open the connection to the database, if it fails, it shows me the ConnectDialog even though I don't have any associated TConnectDialog component, I need it to mark the exception and not show the ConnectDialog. How do I do this?
Number(20) cannot be read!
Hi, using c++ builder 10.3.2, unidac 9.2.1. I have an oracle table with column number (20) populated with numbers having 17 digits create table pelidetail(id number(9), peliid number(10), sortweight number(20), primary key(id)); insert into pelidetail
SQL Server LockTimeout not working?
I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a "Lock request time out period exceeded." error. The SP basically does a lot of table Truncates and then INSERT
BREAKING CHANGE - Default Encrypt with Microsoft OLE DB-Driver 19 for SQL-Server
Hello I create a database connection with all standard parameters (TUniConnection.SpecificOptions) to MS SQL Server MyConnect := TUniConnection.Create; MyConnect.ProviderName := 'SQL Server'; MyConnect.Database := <DBName>; MyConnect.Username := <DBUser>;
Unidac 9.4 and SQL-Server
I'm trying to connect to a SQL-Server database. This works without any problems with Unidac 9.3.0. After installing Unidac 9.4.0 the application crashes. The reported error is 2.5 Type : EMSError 2.6 Message : TCP Provider:_Es konnte keine Verbindung
PgDAC on MAcOs
Hi am testing your Demo Mobile program with Delphi Alexandria 11.3 and PgDAC Version 7.4.0 using Mac Pro Book M2 chip . In this Demo on postgres Schema fish when i use Greek language on Mac not appear correctly Mac Running Windows Running
SetEmptyStrToNull does not work correctly
Hi, we have a problem with varchar fields, wich are not set to null even if we set SetEmptyStrToNull to true. If the value of a field is an empty string it all works correctly, but if we have an fields with a string with only spaces, then the field value
Memory leak in UNIDAC connecting to Oracle
Hello, I'm facing a memory leak in Unidac accesong to Oracle: 1. Oracle 12C 2. Delphi 11.3 First of all, on client side my customer was facing a problem after days the system is running and doing one task that executes every minute, a NET. Invalid pointer
Learning : How to save a Virtual table in SQL Tables
Sometimes we need to store a memory table (Virtual table is the best :) ) in a field of a database table. I present these 2 sub-programs and how to use them as a review. //--------- Wide string to TStringStream
procedure TDMT.WS2Mem(S: string; Var K
EntityDac 3.2.0 and Firebird 2.0.7
EntityDac 3.2.0 Firebird 2.0.7 IBDAC 8.3.0 Expression: From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select(); Result: SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA
TMyDump from v8 to 5.7 charset problem
Hi Is there a way to specify the charset and collation when perforing a backup and restore? We have a clean set of data that we use for install that is on a Mysql 8 server but ur clients are using 5.7 We get the following error. I could perform a replace
Property EncryptedPassword does not exist
Good afternoon, I have a problem with one of the legacy systems here at the company, it is unfortunately developed in Delphi 6. My problem is that I updated the Delphi ODAC that was in version 8.6 to version 11.4, but when updating, when trying to compile
How do I insert an image file into a TVirtualTable Blob field?
Hello, I know how to insert blobs into TUniQueries. But I could not find the way to do this in a TVirtualTable. It does not expose any AsProperty which can sugest I can use a LoadFromStream method. Thank you very much. Jayme Jeffman Filho
TDADataSet
After reading Unidac 9.4.0 Revision History, I have a question: which unit TDADataSet class is declared?
Unidac's TUniquery Can Not Filter Special Four decimal places on Oracle
I have a TUniquery SQL is 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual' and connect on the ORACLE 19c Enterprise， While I try to filter like 'purchase=30.76' or 'purchase_price>30.3706 and purchase_price<30.370600000000001', Both
[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
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
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
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
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
Next Page