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
What is "Serializable Transaction"?
In "New in dbExpress Drivers: Support for RAD Studio 11 Alexandria Release 2 and Microsoft OLE DB Driver for SQL Server 19" https://blog.devart.com/new-in-dbexpres ... er-19.html "Also, we added support for the serializable transaction." What is "serializable
Using ILIKE
Hi there, How can I use "ILIKE" in a LINQ query in DotnetConnect for Postgres? If I try to use Devart.Data.PostgreSQL.Entity.PgSqlFunction.ILIKE, it throws an error "Method 'Boolean ILike(System.String, System.String)' is not supported for execution
Strange behaviour
Hello, I'm using ODBC driver from dynamics 365. I'm experiencing some strange behavior. For example, when I attach Dyn365 database as shared server on my SQL Server, in my queries the TOP 100 clause is ignored. So for example, the query: select top 100
Popular Articles
How to Connect to MySQL Server
In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...
How to Install MySQL on Windows Using MySQL Installer
The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...
SQL Complete activation
Unless activated, dbForge SQL Complete works on the trial basis for 30 days. When the trial expires, dbForge SQL Complete must be activated with a purchased activation key. Note To check the current status of your trial period or the status of your ...
dbForge Studio for SQL Server activation
Unless activated, dbForge Studio for SQL Server works on the trial basis for 30 days. When this time period expires, dbForge Studio for SQL Server must be activated with the purchased activation key. dbForge Studio for SQL Server can be activated ...
dbForge Studio for MySQL activation
Unless activated, dbForge Studio for MySQL works on the trial basis for 30 days. When this time period expires, dbForge Studio for MySQL must be activated with the purchased activation key. dbForge Studio for MySQL can be activated online, offline ...