How to ensure TScSSHClient and TMyConnection both open and / or close at the same time
I like the way opening a TMyQuery automatically opens the TMyConnection that it is connected to. Does TScSSHClient do the same thing? ie if I have TMyConnection. IOhandler -> TScFileStorage.Client -> TScSSHClient will calling TMyConnection.Connect automatically
How does the securebridge demo know which key is the one downloaded from the server?
I have eventually managed to get the securebridge demo (Documents\Devart\MyDAC for RAD Studio\Demos\TechnologySpecific\SecureBridge\Demo) working after deleting references to IdeVer.inc. I am now trying to understand how it does the things the sample
DBF Provider Deleted Flag
Hi, 1. How can this be set to show/hide deleted records? 2. How can deleted records be identified in a table? Thanks
Why is documentation so poor?
Why is the documentation so bad? For example, on the page https://docs.devart.com/sbridge/, under Securebridge Alphabetical Object and Component List (at least I think that's what it is as the left hand side panel is too narrow to display long topic names)
[Solved] Connect named SQL Server instance in Direct Mode
Hello. I am currently testing the migration with SDAC from MS OLE DB to Direct Mode. When connecting to the SQL Server, I get problems when I try to access a named instance, such as "(local)\dunit". If I use only "(local)" then the connection can be established
Better support for DateTimeOffset
Hello I would like to edit database fields in SQL Server of data type DateTimeOffset with SDAC. When I read these fields it works correctly, depending on the definition, no matter what timezone value is in the database. The local time is always read out
Unidac 9.3 - Lazarus
I can't compile LiteDacprovider. has a error on rebuiild the lazarus. Iam using Lazarus Win-32 cross compiler Others providers are ok.
Generate Android 32-bit and 64 bit binaries -> Unit 'MyAccess' not found.
Hello, If I set "Generate Android 32-bit and 64 bit binaries" to True in Project settings / Compiling, I get the error: "[DCC Fatal Error] Main.pas(18): F2613 Unit 'MyAccess' not found." This setting is required for Google Play upload. What can I do?
TNSNAMES not found on 21c
1a) Install Oracle 21 XE into c:\oracle\product\21.0.0 on a machine without any other Oracle server or client installed. 1b) Install Oracle 18 XE into c:\oracle\product\18.0.0 on a machine without any other Oracle server or client installed. 2) Create
Robert Davis
Is the issue with NexusDB provider fixed yet? I'm using the most current trial and it won't work. Says I need to recompile the NexusDBProvider. What is the problem? I'm running Delphi Professional 11.2 w/Update 2 (Alexandria). I'm not going to upgrade
Raspberry
Hi, I do not understand if it's possible use SQLite with Lazarus, but on ARM platform, like the RaspberryPi. In the source folders I see some Lazarus files and fpclinux64.o but not clear to me if compatible with ARM... Thank you
Can I use Odac with Delphi Community Edition to Access Oracle 19c Enterprise Edition?
is Delphi Enterprise edition is Must for Oracle 19c Enterprise Edition access? erkan
VirtualTable/Query are empty after LOADED
Hello I just bought the VirtualDAV (v12.2) Components for my Delphi 11.2 Attached a small demo program, that shows my problem. I load/assigned the data in the LOADED Methode, after i entering on the FormCreate Methode the vtElementGrafik VirtualTable
UniDac 64-Bit MySQL
When linking a 64-Bit C++ project with MySQL UniDac support we get the following error, Unable to open file 'myprovider280.lib' To correct the problem, we have to copy, Devart\UniDAC\Lib\Win64\myprovider280.a to Devart\UniDAC\Lib\Win64\myprovider280.lib
Cann't get autoinc primary key value after UniQuery.Post when SQL include ORDER BY
Select * from table order by col1, Simple SQL like this are fine. Select table1.*, table2.xxxxx from table1 left join table2 left join table3 ORDER BY xxxxxx. When it is such a complex SQL statement, the self-incrementing primary key value is Null after
9.3.0 - Virtual Table Errors
Hi, I detected errors in VirtualTable object. Sample application and information as follows: Delphi: Delphi 11 Unidac: 9.3.0 (nightbuild version) OS: Windows 11 There are 2 problems. One of them is that when we load data into the VirtualTable object at
Features supported
1. Does the driver use the postgres binary or string protocol? 2. What is the level of support for Arrays and PostGIS datatypes? 3. I understand that the driver connects directly, does it support connection using SSL? Thanks
query using "for json"
Hello, I use SDAC 10.0.2 with delphi 7, When I try follow query that return one row & one field (actually is TMemoField) and get field value as string I get part of actual data (2033 bytes). Can anyone knows what is wrong? select * from customer for
SOLVED - UNIDAC 9.1.1 - PostgreSQL 12 - 15 Digit Problem
I started seeing a bug I reported earlier in version 9.1.1 again. Can you help with this? Information: Delphi 11 PostgreSQL 12...15 Unidac 9.1.1 Before Report: https://forums.devart.com/viewtopic.php?f=28&t=54306 ScreenShot: Thanks.
Tmytable not drop
Hello, how do I make it so that a TMyTable that is active cannot be deleted with DROP TABLE ?
Batch Update Oracle Nomal Mode and CLOB
Hi, I use batch update to update records in a query. My query have a CLOB field a the end like this //---- Sql : Update UQ.Sql.Text := 'UPDATE T_MESURES_STEP SET VALEUR = :VALEUR,CODE_REM = :CODE_REM,CODE_U = :CODE_U,METHODE
BDE to MyDac
I am considering converting a large application database to MySQL using MyDAC. I found this page via Google that says: "In MyDAC the interests of BDE application developers were taken into consideration. So starting to use MyDAC after working with BDE
Does the new forum keep track of what you have already read?
Does the new forum keep track of what you have already read? I am logged in.
Delphi Replace Components
I am trying to convert a large project To MySQL using MyDac. I am trying to use Delphi's Replace Components feature and I am getting 'Catastophic Failures.' I also tried it with GExperts add on tool and get the same result. I am wondering if anyone has
UniDAC components for FastReports (end-user designer) FMX 64-bit doesn't exists.
Delphi is a computer language that allows us to write applications for Windows, macOS X, iOS, or Android. https://www.embarcadero.com/products/delphi Universal Data Access Components from Devart (UniDAC) is a set of components that allows Delphi programmers
Are this forum working?
I Cant commit a new topic.
UNidac with Aurelias
Hi I am attempting to use the TMS Aurelius components to connect to Mysql 8 on Linux, using the Unidac components. When I use the Aurelius sqlite connection, everything works fine, however the moment I try and use unidac, it is impossible to start apache.
Oracle Direct and Windows 11
Hi, I have a problem with connection to Oracle in Direct Mode. It Work fine with Windows 10 but with Windows 11 I have this message : "(NET : Network error (cannot connect to server on host '192.168.0.4':0 requested address is not valid in this context
RecordCount and UniDirectional
Hi, I have some query with number of row > 25. With Oracle I use Oracle.FetchAll=True to get correct RecordCount but if I use also UniDirectional = True record is alway 25. PQ.SpecificOptions.Add('Oracle.FetchAll=True'); PQ.Sql := 'Some quetry with more