Recent Topics
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
SQL Complete - Data Viewer
Now is limited to 2033 chars, pleas extend size to 2 MB / 5 MB /Unlimited like option in Studio for query results in grid.
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
Default Font of Excel Exports from dbForge Studio
Is it possible to change the default font of dbForge Studio's Excel exports? Using a template seems to capture and load extra info.
Issue with formating SQL and WITH statement
I'm having issue with formating WITH subquery. Here a simple exemple I have create: WITH client AS (SELECT r.id_region, r.num_region, r.pays FROM region r INNER JOIN pays p ON r.id_region = p.id_region) SELECT cl.id_client ,cl.client_nom ,cl.client_adresse
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
Feature Suggestions : Schema Filter
Feature Suggestions : add a "Schema Filter" function like "Table Filter"
module 'devart.sqlserver' has no attribute 'license'
the problem: import devart.sqlserver print(devart.sqlserver.license.summary) result: Traceback (most recent call last): File "<stdin>", line 1, in <module> AttributeError: module 'devart.sqlserver' has no attribute 'license'
Feature Suggestions for dbForge Studio for PostgreSQL
Here are a few suggestions: 1. Add multi-language support. 2. Add a "Generate CREATE Script" option when right-clicking on a schema (similar to public) or a database, which can generate the CREATE script for the entire schema (similar to public) or the
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
memory leak
memory leak problem is very serious,memory uses will continue grow to several GB level.
Devart Salesforce Source Editor Query
Is there a way to select from account where createddate = GetDate. I am looking to only retrieve records from today. This query doesn't work in the Source Editor select * from account where CreatedDate >= CAST(GETDATE() AS DATE)
Transaction Log multi-select for Undo script
Is it possible in Transaction Log 7.1.45 to multi select rows to generate a custom Undo script? When I Ctrl-click to highlight multiple rows in blue, the Undo script tab window updates to only Undo the last selected row. The Export Undo Script option
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
dbForge Studio for SQL Server Features Question and Feature Request
I was looking at dbForge Data Compare tool and came across the Compare Bundle and dbForge Studio. My question is, am I losing any features from the standalone SQL Complete (currently use Standard), Schema Compare (currently use a competing product but
SSL connection problem in dbForge Studio for MySQL
Hello. I have a problem with SSL connection in dbForge Studio for MySQL on one of my machines. An account in the database has 'REQUIRE X509' option, so it's required to specify a client key, certificate and optionally CA to connect. I have specified all
scroll problem in table editor
hi, as for me something wrong with panel scrolling in table editor also good place for field comment is main column list rather column property. It's only my opinion of course. Thank you
DotConnect for SQLite TransactionScope
Hi, I am trying to use TransactionScope together with EFCore but I am getting this error: System.InvalidOperationException : Cannot enlist local transaction, because current global transaction already contains distributed transactions. Stack Trace: DbConnectionClosed.Open(DbConnectionBase
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
MyDAC login problems
I am using MyDAC 12.4.0 with Delphi 10.2 Using MyConnection1 and Myconnection Dialog Anytime there is a login mistake, wrong password or user, the second attempt throws the flowing error: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
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
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
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)))
dac290.bpl and pgdac290.bpl not compiled into exe
hello one and all, I'm getting back into Delphi, 12 right now, after last use with XE2. I started with 1 in 1995. anyway, I am evaluating PgDAV for direct connection into psql. when I copy and run the exe unto a native win11 machine and run it, the message
MyDAC MyConnection ignores Password
In various circumstances, the TMyConnection "Password" field doesn't seem to work properly. 1. In the Delphi Object Inspector, right after I enter a password into the Password field, if I then set Connected to True, a connect dialog pops up with the Password
Table names always renamed as lowercase versus PascalCase
Is there a way to turn off this automatic table renaming to lowercase? When creating or modifying tables in dbForget Studio for MySQL v10.1.165, it always renames my tables as lowercase or camelCase. Our coding standards are PascalCase, which is causing
invalid bytes count error - DotConnect for Oracle
Hi, we moved from Oracle 12c to 19c and upgraded Devart.Data.Oracle to 10.0.0.0 and to Devaty.Data.Oracle EntirtE6 and we getting that error invalid bytes count right at the start up, during getting user profiles from database. What can be a reason for
Computer crashes when opening SSMS
The two members of my team (including myself), who have dbForge SQL Complete installed, are having issues with our computers crashing every time we open SSMS 20.2. Since it's happening just to the two of us with dbForge, we're suspecting that it's the
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
Update SQLite Direct ?
Hello, Any ideas why you don't update the SQLite direct to the latest version ? Thank you
How to get entire BLOB content with dbExpress
I have a Firebird 3.x database with UTF8 characters, connected with Devart dbExpress from a Delphi Intraweb program and cannot get it to display more than one character of a BLOB memo field. Presumably I need to set something different when connecting
MyDAC and SDAC question
I am trying to retrieve data from MS SQL Server (about 40000 records) and copy them to TDictionary as fast as possible. My problem is that it is slow and some setting changes give strange results. What I do is: 1. I open TMSQuery object MSQArt, it takes
MyDAC Bug 12.4.0
I just switched to the new release and re-compiled my projects. Now I get this error, when I start my program: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
The keyword "then" causes inserting ifthen snippet
Hi, "then" keyword causes to inserting "ifthen" snippet dbforge for oracle 6.0.85
SSMS Results Grid > copy as Excel format
The "Copy Data As" results grid options have been very useful for years, but one extra thing would still be super nice to have: "Copy As Excel". I'm sure everyone has seen issues with data types when copying directly from SSMS into Excel, often changing
Python xbase connector Trial period has expired in the running computer
Hello, I am using the devart_xbase_connector-1.2.0-cp312-cp312-win_amd64 activated in my development computer (Laptop) and it works normally. I have created a utility program that does various things in a fox-pro database which I run on my other PC (Desktop)
no prompts for package procedure parameters
dbforge for oracle 6.0.85 and prev
memory !!
Hi, dbborge for oracle 6.0.85 something wrong with memory consumption and this is not related to large dataset suddenly dbforge was freezing for some minutes and i needed to kill process i have catched same case two times , previous version dbforge have
how to specify the version of sql server used when generating synchronization script
My Sql Server install is 2019. When I generate a synchronization script, I need to specify that the script generated works with Sql Server 2014 (other sql installs on different computers). I am currently using dbForge Schema Compare for Sql Server Professional
Next Page