Problems with Batch Updates
Even in the latest version of mydac I have problems with batch updates. (I told you already on the old forum) The problems started when you released a "faster" and "optimized" batch update ;) Now I can reproduce the error in my app. I have a main app
IBDAC and multithreading
From FAQ "Are the IBDAC connection components thread-safe? Yes, IBDAC is thread-safe but there is a restriction. The same TIBCConnection object cannot be used in several threads. So if you have a multithreaded application, you should have a TIBCConnection
UniDAC 10 Data does not get written to PostgreSQL DB
I'm using PostgreSQL 15.1, Delphi 11.2 I have a simple application (64Bit, if that matters) that uses a connection, the PosgresProvider, TuniTable and a Datasource connected to a dbgrid and dbedit and the With 9.4.0 everything worked. With 10.0.0 I can
BUG UniDAC v10 : @@rowcount is incorrect
Hi, - Delphi 11.3 - UniDAC v10.0.0 - MS SQL 2022 "select @@rowcount" is incorrect with update, insert and delete. no problem with UniDAC v9.3.0 Update of 44811 rows : Deleting a row that does not exist : Thank you in advance Regards
UniDac - Hide SQL oracle from Sqlmonitor Applications
I Need to Block access SQL Scripts from External Applications like SQL Monitor or Other. It can do using Direct Access function from UniDac, bud its is more bureaucratic. There are some form to do this accessing with HostName from TNSName?
Feature Request
Hello, before we started using UniDAC we have used the Direct Oracle Access components (DOA) from AllroundAutomations. The dataset of DOA has a nice feature regarding CachedUpdates. Before it applies any changes to the database in ApplyUpdates, it reads
AlwaysOn configuration
Which options are required to make UniDAC work properly with AlwaysOn SQL Server? If I'm correct options related to AON are: -Provider (should be set prNativeClient) -FailoverPartner, -MultiSubnetFailover We are running UniDAC (version 9.1.1) and our
ODAC Direct Mode Bug: Selecting RAW columns through DB Link causes Access Violation
Hello, Using ODAC version 12.3.0 and Delphi 11.3 Using ODAC with DIRECT=TRUE TSmartQuery has Options.RawAsString=TRUE I have a table like this: CREATE TABLE HAS_RAW (RAW_COL RAW(30)); Insert into HAS_RAW (RAW_COL) Values ('43'); Insert into HAS_RAW (RAW_COL)
How to use TMyConnectionOptions with TMyConnection to set protocol to IPv4 (or IPv6)?
I'm using MySQL Data Access Components, standard edition, version 10.3.2 for Rad Studio 2009 (I'm also using the SSH components to get an encrypted connection) The docs here https://docs.devart.com/mydac/devart.mydac.tmyconnectionoptions.ipversion.htm
IP protocol used by MyDac TMyconnection changes from IPv4 to IPv6 (or vice versa) and database queries fail
Scenario My application obtains the public IP address of the user by running a small PHP script on the same server that hosts my database. I then programatically insert that IP address into the remote hosts table so that I can gain remote access to the
Firebird 5 released
Firebird 5 was released 2024-01-12. Now, when do we get an IBDAC update? ODS is compatible to FB4, but there are new SQLs, like partial indexes and "SKIP LOCKED". There are new backup options for parallel workers, which may be configured in TIBCBack
Compiler Issues with LiteDAC Component
In my C++ Builder XE 11.2 project, I placed a LiteConnection component and attempted to compile an APK for Android 32-bit. During the compilation process, an error occurred: [bccaarm Fatal Error] DBAccess.hpp(17): 'Winapi.Windows.hpp' file not found.
After database upgrade from 19c to 23c, connection in Direct mode gives "NET: Invalid input arguments" error
Hello, A user has a database that was upgraded from 19c to 23c. When the database was on 19c, he could connect using our application (using ODAC in DIRECT mode). Then the database was upgraded to 23c, and now he gets the above error. He says that he can
Migratig from FibPlus
Hi I have a FibDataSet with CachedUpdate activated. and this code: Trans := Consulta.Transaction; Trans.Active := true; Consulta.Open; Trans.Active := false; when I close the transaction, the DataSet state is dsBrowse and all the data are still in DataSet.
Multiple dataset problem
Hi, I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical
Query taking much longer in Direct Mode than when using an Oracle client
Hello, Our product gives the user a choice of using either Direct Mode or using an Oracle client. A customer has reported that when using Direct Mode, a particular query is taking 17 minutes, and when using an Oracle client, it takes only 18 seconds.
Ongoing problems with TIMESTAMP datatype
Hello, This problem with timestamps in the TZR format still exists in the latest version. https://forums.devart.com/viewtopic.php?t=36016 Similarly, I have had this request for years (the ability to configure time stamp format) https://forums.devart.com/viewtopic.php?f=5&t=44301&p=178343&hilit=tzr#p178343
Memory not released after closing TSmartQuery with LOBs
Hello, Regarding this issue, created about 1.5 years ago on the old forum: https://forums.devart.com/viewtopic.php?f=5&t=44418 Your latest answer is: We have reported it to Oracle but have not gotten an answer from them. Can you ask again? Have
[bug] auto-where by RefreshRecord (v8.0.0)
auto-where by refreshrecord works incorrectly with: cross join SELECT bdea.dbrid ba_op FROM bdea CROSS JOIN ab2 WHERE ba_ix = :ab_ix :ab_ix(WideString[3])='100' WHERE ( ba_ix = :ab_ix) AND cross.dbrid = :ba_op :ab_ix(WideString[3])='100' :ba_op(WideString[3])='136'
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
change SQLwait cursor when autorefresh
hi Some of the TMyQuery have Autorefresh enabled. When the autorefresh is executed the cursor changes automaticly to crSQLWait. Is it possible the changes this into the crDefault so the user does not sees the crSQLWait cursor. OR Is it better to use a
Wrong display/update of TIMESTAMP WITH TIMEZONE data in diect mode
For demo, PLS create a table CREATE TABLE TS_TEST ( ID NUMBER (9,0) NOT NULL, TS TIMESTAMP(6), TS_TZ TIMESTAMP(6) WITH TIME ZONE, TS_L_TZ TIMESTAMP(6) WITH LOCAL TIME ZONE ); ALTER TABLE TS_TEST ADD ( CONSTRAINT "_PK" PRIMARY KEY ( ID ) ); And insert
ODAC Pooling
Hi, Greetings! I'm trying to use ODAC connection pool feature, but im having a hard time figuring out how it works. Is there any demo or sample project that shows how it's done? Thanks in advance Rogerio
Possible OraClasses bug?
Hi, During a test, I've had a range check error throw up in OraClasses.pas. It was in version 12.2, but I've just updated now to 12.3 and I think the problem is the newer version as well. I am currently unable to reproduce the error, but I think it had
Adding an TActivityindicator when running long queries. What is the best way to implement?
Some of my queries with Unidaq (Locates, field lookups and updates) take a few seconds to implement. What is the best way to implement an activity indicator when these are initiated? Can I use events to kick off showing, displaying, updating, and eventually
Using INTEGER PRIMARY KEY as 64 bit identity
I am using LiteDac 5.0.1 with Delphi 2007 and I am trying to use an auto-incrementing primary key defined as INTEGER PRIMARY KEY. The field takes values much larger than MaxInt but when I try to read the data in with a tLiteQuery it thinks the field is
UniScript and specific SELECT script won't work
Hi, I use Uniscript with Interbase 7, and with this particular script, nothing append on the DB : SELECT GEN_ID( my_gen, MAX(id) - GEN_ID(my_gen, 0)) FROM my_table; (The generator my_gen should have taken the max value of my_table.ID). And no error were
TMSTable.post problem: Operation Aborted. How to get more detailed information ?
Hello, Using an TMSTable with 82 fields, and 1 keyfield (integer), I'm able to Insert, Delete and Edit, but when I execute Post, the operation fails with exception: Operation Aborted and no further information. If I delete the record and then Insert,
Issue with Inserting Current Time Using Now Function in Timestamp Column in Delphi 12 and UniDac 10.0.0
I have a problem with compiling in Delphi 12 with UniDAC 10.0.0. Everything works in Delphi 11 with UniDac 9.4.0. Database is Postgres. When I want to insert the current time into a table item that is of the timestamp type using the Now function, an error
BLOB With VirutalQuery Oracle
Hi, I need to use VitrualQuery to transfert Tables, table with clob et blob, but if I done the folowing code. With Postgres at the end Table2.Memo is filled by with Oracle is Empty. If I execute 'INSERT INTO TABLE2 SELECT * FROM TABLE1' in sqlplus it
Delphi 12 components
Hello, Delphi 12 has been out for 3 days and I see that it is not possible to download SDAC components for this new version. When can I expect components for version 12 ? I'm a bit surprised that there are no components on the same day that Delphi comes
F2063: could not compile used unit 'MyAccess'
I'm using the new MyDAC 12.0 professioal in Delphi 12.0. I get this error. The same for the unit 'DbAccess'. This version of MyDAC in Delphi 11.3 works fine. Is something wrong with the paths? Incompatible .dcu ?
RAD Studio 12 support
Any idea how soon after launch that MySQLDAC (Delphi Components) will be updated to be used in RAD Studio 12 ? Or can it be installed in RAD 12 now?
UniDAC Update - Delphi 12
Delphi 12 has been released. When can we expect an update of the UniDAC components?
PostgreSQL column default values
Hi, I'm using PostgreSQL 15 with Delphi 11 and latest UniDAC components. Create a table: CREATE TABLE sample (col_a VARCHAR DEFAULT 'A'); Then use a TUniQuery that "SELECT * FROM sample", add a TDataSource linked to the query and a grid and dbnavigator
SDAC version 11.0.0 not yet available for Delphi 12
Hello, I have received the notification that SQL Server Data Access version 11.0.0 and VirtualDac 13.0.0. is available for download. When I go to my profile to download the version I noticed that the Delphi 12.0.0 version is available for download.
TUniQuery - how to assign JSON object to it?
Can someone please give me an example how to assign a JSON object (got from HTTP response query) to TUniQuery component? In Delphi (10). Thanks.
Oracle 11 XE - Error ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Hello, I have a problem with Oracle 11 Express Edition after upgrade ODAC from 10.1.3 to version 12.3.0 (Delphi 10.2). When I try to update a table with a CLOB field, I get ORA-24816 error (Expanded non LONG bind data supplied after actual LONG or LOB
Setting Servername with Port doesn't change port sind 10.2
With older version we only could set the servername in form of "server.local,1434" and the connection could be opened. When I use Version 10.2 the Port of the connection still stays on default 1433. Connection can than not be opened.
cannot insert unicode value in table (Mydac 9.1.3 for RAD Studio 10.2)
Hi, I have create a very simple database to test inserting unicode characters: CREATE TABLE `tencodingtest` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `value_as_utf8` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `value_as_utf16` varchar(30)
Next Page