• Devart Postres pgDataReader/PgDataAdapter Decimal value with Precision

  Could someone please help me with the following question... I migrated the Assembly Devart version to Postgres Express to version 8.0.0.0... after the changes the decimal value that is brought from the PgSqlDataAdapter is coming numerically with precision

• 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

• Avoid describing all source and target objects on data comparison

  Hello, we are planning a full DB migration, with lots of tables involved, that require us to define and execute different dbcomp files in order, as there's dependant data involved. dbForge does the job perfectly, however, we do see a major slowdown in

• Error when opening EDML from VS2022

  Starting a few days ago, I am experiencing this error when opening the EDML within VS2022 that was working before:

• Unable to connect SQL server database

  I write a code on databricks python notebook to connect My SQL server database through ODBC but it's showing error as in attached file.  Pls provide me solution ASAP.

• TRttiUtils : Documentation

  Could you please provide the documentation for the TRttiUtils class and an example of use TIA

• STRING_TO_ARRAY

  i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'

• 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

• Change sqlite version

  How to update sqlite version? For now sqlite 3.40 is newest but it's 3.36 in devart 6.0.x package.

• 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

• Sample size while mapping

  Hi I am trying to import a large dataset from a csv. When using the wizard, it is eventually setting the type and the max. lenght of each column, using a sample of 100 (?) lines. How can I tell the wizard to use a larger sample, like 10.000 lines?

• 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 ?

• ODBC Connection SQLSERVER to HUBSPOT

• Schema Compare doesn't support unique indexes which contain CASE statements

  We have a unique index that contains a case statement: ADD UNIQUE INDEX uk__phone__org_id__phone_number(org_id, ((case when (`org_id` <> 2) then `phone_number` end))); We added this index to our database project and when we perform a schema compare between

• 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

• Data Comparison. Describe Objects

  I have two databases with each schema containing 171,000 tables(Since it is an ERP application). I want to compare a select few tables only, but first I need to load all the objects.  Steps performed: 1. select New data comparison option 2. Select source

• SQL Complete - Is there a way using the formatter to ensure spaces exist between brackets in the where clause

  Is there a way using the formatter to ensure spaces exist between brackets in the where clause? example: WHERE (Column1 = @Column1 Or Column1 > 0) would become WHERE ( Column1 = @Column1 Or Column1 > 0 )

• dbforge for Vitess

  Hi Team, We are trying to use dbForge studio with an existing Vitess based MySQL cluster but are not able to view the database schema. Can someone please confirm if dbForge supports Vitess based MySQL cluster ? When adding our vitess db with our credentials,

• 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.

• Generate Entities Prefixed with Schema Name

  Hello,  We are evaluating Entity Developer for purchase. We currently use "EF Core Power Tools". One of the few nice things about it is that when using Database First, it generates entity names that are prefixed with the schema name followed by an underscore.

• 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

• Connect to Microsoft Analysis Services

  Is it possible to connect to Microsoft Analysis Services using dbForge Studio? I'd like to use dbForge to query SQL data in Analysis Services

• 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

• dbForge for SQL Server

  Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server

• dbForge for MySQL

  Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL

• dbForge for Oracle

  Discussion of open issues, suggestions, and bugs regarding database management and development tools for Oracle

• dbForge for PostgreSQL

  Discussion of open issues, suggestions and bugs regarding database management and administration tools for PostgreSQL

• Code Compare

  Discussion of open issues, suggestions and bugs regarding file and folder merge tool – Code Compare

• Next Page

• Most Discussed Topics

• dbExpress Driver for SQL Server support for TLS 1.3

  Does dbExpress Driver for SQL Server supports TLS 1.3?

• SQL Complete not appearing in SSMS 20 on ARM64

  Running Windows 11 ARM64 and SQL Complete installs quite happily but then does not appear in SSMS20. SQL Complete does appear and function in Visual Studio 2022.

• Why Does dbForge Studio Say a Query has 302 Records Retrieved?

  Paginal mode is off. A query can return thousands or hundreds of thousands of rows but the grid always reports 302 until you start scrolling through the data.

• ODAC - base class for BeforeOpen

  Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery

• Stop tab rows from shifting in dbForge Studio

  I have "Show tabs in multiple rows" on. Is there a way to stop the tab row of a clicked tab from always being moved to the bottom row? It's not helpful having tab positions always being moved around and no other IDE I use does this.

• Popular Topics

• dbExpress Driver for SQL Server support for TLS 1.3

  Does dbExpress Driver for SQL Server supports TLS 1.3?

• Table Designer in dbForge Studio

  When the property pane has focus in the table designer, hitting Tab should go to the next property, not the script pane.

• SQL Complete not appearing in SSMS 20 on ARM64

  Running Windows 11 ARM64 and SQL Complete installs quite happily but then does not appear in SSMS20. SQL Complete does appear and function in Visual Studio 2022.

• TscSSLServer broadcast to clients

  I have a TscSSLServer with connected TscSSLClients. The Clients can send a message to the Server. And the Server can send a message to the Client in its AfterSessionConnect event. But if I try to send a message to the connected Clients via a forms button

• ODAC - base class for BeforeOpen

  Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery

• Popular Articles

• How to Download and Install a Previous Version of the Product

  If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...

• 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 Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

  If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

• Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce

  When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...

• 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 ...