Recent Topics
SQL Formatter Select List Margin Break
Hi there. Is it possible to break the SELECT list at a particular margin point? I'd like to leave the Select List "Stack Columns" option as Single Line, but I'd like to be able to specify when the Select column list should break to a new line. Is this
Module Class connect() method ConnectMode = "Unsafe" parameter
Hi All, I am using this connector for a few days now and I am quite happy with it. Recently I had to deal with a connection to a 3rd party Visual Foxpro database in which I couldn't connect because the dbf file I wanted to access was locked by another
XDBGrid sort function doesn't work
I'm using the XDBGrid sorting feature in FireDac, but it doesn't work in uniDac. If you have any solutions, please let me know. XDBGrid Designer -> Contrlo2 -> sortingControl
Solution made with Mysql for Visual studio 12.0.1
Hello, I am trialing Devart dotConector with Visual Studio 2019. I have a full vb.net solution, which has datasets (XSD) created by MySQL for Visual Studio. I was hoping to just migrate these across to use the Devart.mysql.data namespace (from Mysql.Data.mysqlClient)
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,"
Passing parameters to TUniStoredProc without SELECT privilege
Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors
Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,
Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)
Is there any difference between Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)?
.Net 9 / EF Core 9 support
Hi, What is the roadmap / delay to support .Net 9 / EF Core 9 on the Devart.Data.MySql.EFCore library ? Regards.
Data management system
Data is the backbone of generation
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
This server version 17.1 is not currently supported
I installed the latest dbForge Studio for Postgres. Running on windows 10. Postgres container (latest version from last week) is running in docker desktop for windows on port 5432. When I am creating the connection, dbForge studio is able to connect and
How to disable formatting of Stored Procedure/Function code in backup?
In some Functions I format the code myself. However, in the backup copy my formatting is lost, and instead it is replaced by automatic formatting. How do I prevent this? I use dbForge Studio 2020 for MySQL
Live Data
In the latest version of dbForge Studio for SQL Server is there any 'live data' functionality to show rows populating as a simple query executes instead of having to wait for the entire query to finish before showing results? For example: select * from
SQL Complete Execution History Import
Is there a way to move over query execution history from one computer to another?
Set connection parameters via command line
Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?
UniLoader has problem with importing data to a table with default value columns in MSSQL.
Hello, UniLoader has problem with importing data to a table with default value columns in MSSQL. I received an "unspecified error" message. If I provide the data myself, it works fine, but I would like the data to be filled with the schema's default value.
I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition"
Hi, I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition" What have I do?
Skip exception
hi all ! I have the following code that returns a bool value. If there is no connection it should be false. The problem is that I always get the exception and get out of the program. Is there a way to avoid it? private static bool IsMariaDBServer(string
How to show table name on windows with retrieved data?
When I'm retrieving data from table through context menu option in previous versions on opened tab was shown name of the table. But now its just "SQL", "SQL1", "SQL2"
SOQL error: unexpected token: '('
I have a complex SOQL query that includes nested queries of child objects that works in the Salesforce workbench but fails with the error "OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Invalid SOQL:
DIRECT Mode fails with "Net: error 99" if a TYPE is modified between uses in a SELECT
Hello, Using the attached demo project with the latest version of ODAC and Delphi. You'll have to enter your own user/pass/server. The bug happens on any Oracle version. After connecting in direct mode, a script runs which does the following: 1) Creates
TUniLoader
I'm using TUniLoader with SQL Server and it works fine. I would to know when the component finishes writing data on the database. Is it at the end of OnPutData event?
Entity Developer issue with nullable DateOnly
I am in the process of upgrading our apps to .net 8 and EF core 8 and have also upgraded Entity Developer to the latest release. However, I am having an issue with DateOnly fields. If I mark a database field as DateOnly and nullable = true, the resulting
Schema compare for PostgreSQL 1.4.839
Very good tool with minor exceptions. For now I miss compare for triggers and indexes. Didn't test partitioning yet (is this working).
Firebird query statistics, int32 of int64?
Hi, In my application, I'm using TIBCConnection.DatabaseInfo to fetch query statistics, the Reads/Writes/Fetches/Marks fields. These are int32, but I think these should be int64. Can you check with the API? Here's an example of values that clearly overflow
Direct connect to MS Access in 64bit application
Hi, Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode. Delphi 10.4 and UniDac
SSMS 19.3 no SQL Complete after installation
Hi. Yesterday I installed SqlComplete 7.0. Everything went smoothly until I saw there is no SQLComplete menu in SSMS 19.3. There was no indication of error. I tried it twice, with same result. What should i do? How do I troubleshoot this? Thanks.
securebridge with mydac
ThirdParty demo mydac are SecureBridge(Deprecated) and SecureBridge With last delphi 12 with patch wich one should be install deprecated has MySSHIOHandler and MySSLIOHandler In mydac connection handler properties have no longer available components if
Received error message not overriden in inherited class
with securebridge (ssh connection i received this error message. In local connection not received nothing Any idea why I received this error see attach file
Errors testing backup db with 20+ tables total 10GB
Hi, My first question evaluation dbForge Studio for MySQL, after a few days testing other stuff through the evaluation of ENTERPRISE. The "only" special circumstance is that it is on a MariaDB 10.4 db enginge with tables in innodb. I have verified that
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
Unable to use dotconnect for postgres
I recently had to get a new computer and a previous web services site that worked fine under VS 2017 does not work under VS2022 and the error is when accessing the entity I get the following exception. Keep in mind the exact same site is working in production.
Oracle AQ - Dequeue from a sharded queue causes invalid cast exception
Since i converted my Oracle queue into a sharded queue, the OracleQueue.Dequeue function always throws an invalid cast exception in Devart.Data.Oracle.dll. When i used a normal queue everything worked fine.
Oracle-19-24 issue in DirectMode
Hi, We have the same issue: https://support.devart.com/portal/en/community/topic/oracle-19-24-aso-directmode Is there any forecast for the release of the official version? Could you give us the access to the pre-release build? Regards
System.AccessViolationException when having parallel db writes using Devart.Data.SQLite.EFCore
Hi, I've observed and AccessViolationException when running unit tests in parallel. Investigating this I found out that creating multiple different databases, or even inserting new entities in a database, in parallel can cause this exception: Fatal error.
'relation "__EFMigrationsHistory" already exists' when running multiple migration sets
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.
Specify synchronization Order
This other software allows to specify the synchronization order so that integrity errors don't happen like foreign key issues. Is this possible with your current version of Data Compare? This is important to avoid, for example, having to disable a ProductPhotos
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
Next Page