Recent Topics
How to use dotConnect for Oracle Express Edition?
I am using dotConnect for Oracle Express edition, Can I reference to the library using NuGet or have to install manually?
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.
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
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)
Feature Suggestions : Schema Filter
Feature Suggestions : add a "Schema Filter" function like "Table Filter"
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.
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
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.
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.
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.
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
#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),
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
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
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
Next Page