Recent Topics
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.
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
Reset/Set Sequence in PostgresQL programmatically from c#
Is there a way to programmatically (c#) to update a sequence value in postgresql? I know from a sql perspective, you can do something like: SELECT setval('my_sequence', 10, TRUE); How do you do this with the devart.postgresql dotConnect for Postgres
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
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
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
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.
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.
#28000Access denied for user @localhost (using password: NO)
I have a large application where i : i have 14 datamodules. there's 1 main datamodule which contains the MyConnection component which is set at runtime and at design-time the connectionstring is empty every datamodule has a OnCreate event on all datamodules
New BOOLEAN datatype not supported with Oracle 23ai client
Hello, I am using the latest version of ODAC and Delphi. When I connect to an Oracle 23ai database, using an Oracle 23ai client, and I select (using TSmartQuery) from a table that has a column of datatype BOOLEAN (for example: Select * from user_domain_cols),
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)))
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
memory leak
memory leak problem is very serious,memory uses will continue grow to several GB level.
schema comparison "Ignore white spaces" option issue
After completing schema comparison with the "Ignore white spaces" (in script objects) being checked on then next comparison (either invoked manually or re-run automatically) is conducted with the "Ignore white spaces" being checked off. Why does it work
Card View issue 10.0.46
Maybe I overlooked something but it looks like card view is working improperly in 10.0.46. It was OK in the older versions. 1. The width of the box is too narrow so many of the values are cut off. 2. I can't find any way to easily change its width. The
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.
What happend to dbForge Studio for SQL Server?
Hi there I have now updated to the latest version of dbForge Studio for SQL Server. And in hindsight, that was a big mistake. - The time it takes for the program to start has increased by a factor of ten - Intellisense no longer works automatically -
Secure bridge sign PDF
hello i need help about signing some PDF file, with secure bridge... Some examples, sign with PFX or from smart card...
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
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
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)
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
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
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
Next Page