• Documentation tool doesn't generate flow diagrams for Stored Procedures?

  I'm puzzled that such an important feature for those of us converting legacy databases to a more modern architecture don't have any tools that can flow diagram T-SQL stored procedures? I feel like your products are dancing around "real world" developer

• VirtualQuery IsNULL

  Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE

• SqLite Localized Order

  Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception

• Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"

  We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",

• Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"

  We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)

• Cannot find Datamodel.hbml file error NHibernate

  I am following the instructions for database first creation. However, at the end, the template fails to find the hbml file in the appdata folders. This only happens with NHibernate templates.

• .NET 9 - devart.Data.Oracle.EFCore method not found

  Updating everything for .NET 9.0 and suddenly I get the following error: System.MissingMethodException: 'Method not found: 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlConstantExpression Microsoft.EntityFrameworkCore.Query.SqlExpressionFactory.Constant(System.Object,

• Batch move and creating destination table in Access

  Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access

• Is there a better way to view this panel info?

  When viewing indexes for a table, the index "details" panel (see image attached) is incredibly awkward, being compressed into a small space. Is there a way to better view that panel to use it more easily? e.g. a different window/panel arrangement or an

• Compare to schema inside same database

  Hi, I started to evaluate DbForge Studio for PostgreSQL. I wan't to compare schemas inside database. (I mean those schemas which are created by CREATE SCHEMA myschema); our use case is for example a franchising chain, where all companies are under same

• ODAC local filter raises EVariantTypeCastError

  We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS

• SecureBridge TscSSHClient irregularly causes critical crash in FMX app on IOS when disconnecting

  Hello, after refitting a mobile application with SecureBridge to enable SFTP data exchange I have encountered the following problem: In irregular intervals the app crashes fatally when performing an SFTP data exchange. With the help of the debugger I

• DBExpress driver for PostgreSQL

  Hello, I've read that you can't use multi transaction with Devart drivers for PostgreSQL. But I also read that PostgreSQL seemed to support it. Can you tell me what's going on? Thank you in advance. Lbn69

• ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params

  We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I

• EntityDAC developer on Oracle

  Hello, I'm trying to use Entity Developer to generate model for my Oracle database. It seems that after model generation some table are not still present in the database. I'm using Entity Developer version 6.12.1354 trial. Thank you, Luca

• dotConnect C# MySQL: Setting charset at global level?

  I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset

• When connect via SSH to Mikrotik, the byte stream is broken

  For example, when executing the command: ip/service/print detail proplist=port value-list where name=api We get the result: ip/service/print detail proplist=port value-list where name= [admin@MikroTik] > ip/service/print detail proplist=port value-list

• Access denied for user 'x'@'ip' (using password: YES)

  Hello, This is maybe a strange question, but I am evaluating the mysql connector and I started by trying to generate a model Entity Developer (with entity framework - database first approach). The problem is that I am not even able to connect to my server,

• Intellisense/Suggestions for Locally Created Temp Tables?

  I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including

• Universal Error in Mysql

  hi all ! Im getting the following error and I dont know whats causing it. Exception thrown: 'System.NotSupportedException' in Devart.Data.dll UniDbType not supported by current data provider This is how I setup the connection public new Devart.Data.Universal.UniConnection

• 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,"

• 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

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

• Next Page

• Most Discussed Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• Unidac connect to Oracle with LOAD_BALANCE

  Hi, it's the first time I have to connect to an Oracle server in a datacenter with Load_Balance feature; I have received this connection string: PROD_SIT_DB_PROD= (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.148)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.149)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.150)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDB.subset.vcnphx.oraclevcn.com)))

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• Findkey in Cloned DataSet work?

  Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• Popular Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• Connect to MySQL with SSL and validate server certificate

  Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification

• Newer Version of SQL Complete Breaks Stream Deck Macros

  Using SSMS 20.2. Stream Deck https://www.elgato.com/ca/en/s/welcome-to-stream-deck is a piece of hardware or an app that hooks up to your PC and provides extra macro keys. I have text strings assigned to some of these macro keys. Until SQL Complete v7.0.362

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