UniScript unterminated dollar-quoted string
I have a problem with Uniscript when running the command below CREATE OR REPLACE FUNCTION public.fin_fc_cte_integracao_fin() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE vFlgBaixado boolean; BEGIN IF (TG_OP = 'DELETE') THEN SELECT (CASE WHEN dat_bai
OptimizedBigInt on Mysql 8.*
Hi, I have OptimizedBigInt on in options, and in MySQL server 5.7 this SQL works well and produces an integer field type: FLOOR((DATEDIFF(CURRENT_DATE, STR_TO_DATE(Birthdate, "%Y-%m-%d")) / 365)) AS Age But on MySQL 8.*, I am getting: Type mismatch for
Unitable with postgreSQL (v17)
I'm using TUniTable with postgreSQL v17. When I open semi large table (140 000 rows, 220 fields) with unitable it takes 3-4 secods. is there any way to avoid this delay, like take just first record etc unidac is latest 10. Server version: PostgreSQL 17.0
How much time does it need Devart to fix bugs in ODAC?????
Honest Question on ODAC Support Quality I am in the process of porting a massive application (5 million lines of code) from DOA to ODAC. The application uses an intermediate access layer, so my job is to port this layer from DOA to ODAC. I started this
Can ODAC connect in Direct Mode with Kerberos?
Hello, Our application has an option to use ODAC either in Direct Mode or using an Oracle client. When a client is used, customers can connect using Kerberos without any problems. That is, once it is configured in SQLNet.Ora and the Kerberos configuration
IBDAC : TIBCQuery and TIBCEncryptor
Hello, TIBCEncryptor work fine with a TIBCQuery connected to a Grid or if you do Dataset.insert or dataset.post. But it's doesn't seem to work if you add record with a TIBCQuery using execSQL like this ? MyQuery:TibcQuery; MyEncryptor:TibcEncryptor; ...
SDAC SQL Server 2022 (express) - Connection forcibly closed (10054)
I have just released a new version of our main product to a select few customers, and I've already received a bug report with the following error: Error on data writing to the connection: An existing connection was forcibly closed by the remote host.
SQL Server 2022 - Native Client
Hi I've read that the native client isn't recommended for new projects. I currently use SDAC and use prDirect as the provider, but I wondered, what your plans are for the prNative option? Thanks Chris
Advice for using VirtualQuery
Hello, We are developing software under Embarcadero Sydney with TUniQuery component on Firebird or SQL Server DataBase. We have noticed that using a VirtualQuery is much faster (especially when sorting). From there I have two questions : 1. Question ----------
Occasional access violation in ODAC 13.3.1 when TOraSession is destroyed
Hello, We recently updated from ODAC version 13.2.1 to 13.3.1 and are now seeing an occasional access violation when TOraSession is destroyed. I am not able to reproduce this at will so I cannot provide an app to demonstrate the bug at this time. I do,
TScSMTPClient.AuthenticationType no longer available?
Hi, today I upgraded my SecureBridge from version 10.4.1 to the recently released 10.6.0. When I went to compile my project I found that the TScSMTPClient.AuthenticationType property is no longer available, so I can't define an authentication type before
Store RTF text
I am using Unidac 10.1 with Delphi 11.3. I am using an inherited component from TcxRichText from Developer Express to store formatted text with RTF in database. I am using MS SQL Server with type NVARCHAR(MAX) on the column. My problem is that rtf text
How to support non Unicode fields when using TUniConnection 10.2.1 to connect to SQLite database?
TUniConnection 10.2.1 When connecting to an SQLite database, because the field type of the table in the SQLite database is varchar (100) instead of Nvarchar (100), it is intuitively not a Unicode database, My current problem is that when I compile a program
Is SecureBridge 10.5.0 compatible with RAD Studio 12.2 - Patch 1
Hi, When I try to install SecureBridge 10.5.0, with the recently released RAD Studio 12.2 (Patch 1), i get warning message. "You are using a version of RAD Studio 12 that is required for SecureBridge 10.5.0." Is SecureBridge 10.5.0 compatible with RAD
RAD Studio 12.2 Athens Inline Patch 1 / UniDAC 10.3
UniDAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1.
What does "Net: Invalid VerifierType" mean?
Hello, A user is attempting to connect to the database with ODAC in direct mode and receiving the error "Net: Invalid VerifierType". What does this error mean and how can it be solved? I see it in OraNetLogon.pas, around line 1529 but of course I can't
RAD Studio 12.2 Athens Inline Patch 1 / ODAC 13.3.0
ODAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Starting Delphi 12.2 shows errors like this (german version): "Der Prozedureinsprungpunkt "@Idetheme@Utils@TIDEDialogRegistryServices@$bcctr$qqrv" wurde in der DLL "C:\Embarcadero\Studio\23_components\ODAC\Bin\Win32\oramigwizard290.dll"
MyDac 12.3 and RAD Studio 12.2 Athens Inline Patch 1
MyDAC does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Can you please update the install file?
UniDAC fails to load in Delphi 12.2 Patch 1
Tried reinstalling but still get entry point error when opening Delphi.
UniDAC SQL Server - prDirect vs. prNativeClient
I use prDirect for SQL server now. My question is, if there is any advantage when I use prNativeClient or prMSOLEDB compared to prDirect? Christian
UniDAC DBF Provider Insert Into Temporary Table
SELECT * into #AA from XYZ gives an error. How can this be done?
PostgreSQL version 17
Did somebody already test UniDac 10.3.x with the latest PostgreSQL version 17.0? Everything ok or are there any known problems? Regards Christian
TUniStoredProc fails when connection has parameters
Hi, I have simple UniStoredProc it works fine if I don't define any parameters to connection. But when I add 2 parameters to uniconnection UniConnection1.macros.Add('false','0'); UniConnection1.macros.Add('true','1'); I get error [Zen][ODBC Client Interface][LNA][Zen][SQL
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
PostGreSQL/10.3.0/BLOB
Hi, I have updated to Unidac 10.3.0 and I've a problem with the code below : //---- Sql - Sauvegarde des lignes existantes LQ.Sql.Text := 'SELECT MAT_ID,INT_DEB,DIM_EXTENSION,DIM_DATE,DIM_SOURCE,DIM_LIBELLE,DIM_FILENAME,DIM_ID,DIM_ORIGINAL FROM T_DOC_INTER_MAT
Log für TScSMTPClient verfügbar
I use SecureBridge - TScSMTPClient in Delphi 12.2 to send e-mails. It works very well. Is there a way (and an example) how I can log the connection setup, sending and disconnection, similar to a logger? Best regards Gerd
Unidac UniQuery clone access violation
When I use a TUniQuery and perform a CloneCursor using postgres, If I pass "True" as the reset parameter, an access violation error occurs. Attached are the database and the demo file as an example.
Add a field named index to the DBF table
There is a dbf table with a foam structure. It is necessary to add a field with the name index. Variants UniQuery->SQL->Text ="ALTER TABLE \""+System::Ioutils::TPath::GetFileNameWithoutExtension(OpenDialog->FileName)+"\" ADD COLUMN &fldname CHAR(10);";
Issue Unigui / SDAC
I have a problem that occurs with Unigui with SDAC I have two forms, both have a grid connected to a Query (TMSQuery to be exact). I open a popup and select a record, but when I close it, the first form record always moves to the first record. 1- Prepare
Continuous MFA Prompts
Highlights: Linux Server / MySQL / MariaDB / PHP 7.4.34 (upgrading soon!) Windows Client (current version) Connection Type: TCP/IP with SSH and MFA (prompt to my phone) Trial version Issue: I connect just fine and can see everything. However, when I do
Postgres: Performance-Issues after updating from UniDAC 9.4.0 to 10.2.1
Hello, we massive perfomance issues after updating to your newest version. For example: TUniTable (default settings), TUniConnection (already connected), Table with 621 Records - Version 9.4.0: Open returns after ~25ms - Version 10.2.1: Open returns after
Timestamp with TZ field date shifted +66 hours
Hello, Please connect as SYS with direct TCP/IP to an Oracle 19c database. Use an TOraQuery with the following SQL: select /*+first_rows*/ ORIGINATING_TIMESTAMP, HOST_ADDRESS, container_name, module_id, process_id, message_text from v$diag_alert_ext where
PostGres reserved Word
Hi, I'have a table with field INT1,INT2,INT3. On Oracle if I worte SELECT * FROM MyTable WHERE (INT2 = :INT2) it work fine but in postgres params.count = 0, INT2 is a reserved word in Posgres. It Works if I change the query in Format('SELECT * FROM MyTable
SecureBridge: Prevent File Creation with TScSFTPServer
I am uploading files with a SFTP Client to a TScFTPServer, but I want to process the stream directly without creating a file alongside it. I tried overriding OnWriteFile, but then an empty file gets created, which I want to avoid. It seems like OnOpenFile
Connecting to Oracle Autonomous instances with Unidac
Hello, We are using Unidac in Delphi 11 to connect to Oracle Autonomous instances in Direct mode but we can't get it to work. If we give "adb.region.oraclecloud.com" as the server and valid user/password credentials, we receive the following error: ora-03113
UniDac DBF Direct Connection - PACK Table
In the UniDac documentation, in the native DBF provider section a mention is made that PACK-ing of DBF tables (files) is supported. Searching the source code I came upon the TDBFDBase class which implements the PackTable method. I tried to use it by creating
Unidac - MSSQL - Linux
Hi everyone I am migrating a REST application (DMVC Framework) that uses Unidac to access a MS SQL Server 2022. When executing a query with data containing accented characters, all of them are replaced by "?". When compiled and executed on Windows, the
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
SDAC Connection Pooling with TWebModule in Linux environment
We are trying to evaluate whether we can, and exactly how, we can use connection pooling with TWebModule in a Linux env (Apache specifically). We have essentially stripped all threading from our application as it does not seem to play well under Linux.
Delphi TMSStoredProc parameter issues
Hello, we are replacing ADO with SDAC in our application. I cannot get one thing work.. myAdvStoredProcedure := TMSStoredProc.Create(nil); myAdvStoredProcedure.StoredProcName := 'GetCustomerTest'; myAdvStoredProcedure.Params.Clear; myAdvStoredProcedure.Params.CreateParam(ftInteger,
Next Page