Recent Topics
Advice on which Unidac components to use in android app
I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery
Handling of NaN > DevArt Connection Exception
Hi, PostgreSQL DataAcess Components if there is "NaN" in a Numeric column (that is allowed per default by postgres). Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000
The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.
I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created
Invalid Typecast exception on Insert/Update blobs
Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++
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
Virus scanner alarm - Trojan found
Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from
Will dbForge for Postgresql filter out comments when submitting queries?
Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation
KeyNotFoundException when using Oracle spatial functions in EF Core 8
Hello, We are in the middle of upgrading EF Core 6 to EF Core 8 along with upgrading from .NET 6 to .NET 8. We found and reported an issue when analyzing this upgrade. That issue is here: https://support.devart.com/portal/en/community/topic/unexpected-sqlparameterexpression-implementation-when-using-oracle-spatial-functions-in-ef-core-8
How to search within stored procs with dbForge for MySql
I would like to be able to search for text and have it look at stored procs and column names, stuff like that. Basically I want something like Redgate's SQLSearch tool for SSMS. Is that in dbForge Studio already or can I request something like that be
Change order of ApplyUpdate
Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant
Sql Complete v2025.1.134 won't switch to express license
I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't
AI Assistant code generation incorrect (missing chars)
I've been working with testing query optimization this morning and finding that the generated queries are not displaying the greater than or less than symbols. For example, a condition 'WHERE someNum <> 0' gets generated as 'WHERE someNum 0'. Any way
Restoring Tabs After Restart Getting Worse
dbForge Studio for SQL Server 2025.1.124 seems to be noticeably worse at restoring tabs after a restart. I'm down to two sql tabs being restored from about the ten I had yesterday after a couple of restarts.
New AI Feature in dbForge Studio for SQL Server
Good start but a bit rough when actually using it, both in terms of UX and output. My first prompt, "Explain this query", resulted in a 500 internal server error. I figured out I had to include the query with the prompt but in these cases, Studio should
How can I get SQLComplete to format Table Check constraints?
I'm using SQLComplete version 2025.1.134 and have the following table definition: CREATE TABLE MyTable ( [Column1] INT NULL ,[Column2] INT NULL ,CONSTRAINT [CK_MyTable] CHECK ( ( (__Universe2HybridBenchmarkId IS NOT NULL AND __Universe2AccountBenchmarkId
dbforge studio4oracle problem restoring windows/toolbars layout after restart app
Hi. reproducing case: 1. make any changes in windows/toolbars layout what differ from default, 2. place and pin find and replace dialog as on image 3. restart app windows and toolbar layout will be reset to default dbforge studio4 oracle v 2025.1.134
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
Suggestions for optimizing the log output function
1、SQL1.sql truncate aaa; truncate bbb; truncate ccc; truncate ddd; truncate eee; truncate fff; truncate ggg; truncate hhh; truncate iii; truncate jjj; truncate kkk; truncate lll; truncate mmm; truncate nnn; truncate ooo; 2、SQL2.sql truncate aaa; truncate
DbForge studio for Oracle connection issue with proxy user
I have oracle DB that is installed on server and want to connect to it via proxy user but it's seems like the application can't connect to the DB even the same connection string is working fine on other application. Please note that I have no DBA privilege
Debug SP in SQL Studio
Hi I am trying to debug SP in Studio for SQL Server it is workign well and, I also can see veriable value which declare in SP like int or nvarchar veriables. but if i ma using tbale veribale like , CREATE TABLE #TempValidation ( TempValidationID INT IDENTITY(1,
dbForge Extented Event Profiler for SQL Server
I have downloaded the dbForge Event Profiler in the recent version 2025.1.134 and installed it. When the UI opens and you click on anything but nothing will work ..it hangs for a bit and nothing happens. not even the help menu is working. There is no
Many pages like Manual Product Activation ends in 404
Parts of your guides and information and website is broken. I often end up in a 404.. like on this: 3. Open the Manual Product Activation page of the Devart web site, and paste the copied text in the text box. Click Download license. The license file
connection "forgot" parameter "enable DBMS output"
Hi, after automatic reconnection connection "forgot" parameter "enable DBMS output". dbforge studio for oracle 2025.1.34
UUID V4 and V7 are now available, Is it in DBForge ? If not, can it please be added
HI ! I see that UUID_V4 and UUID_V7 are now implemented in MariaDB v 11.7 (11.8.2 is the current release) https://mariadb.org/always-use-the-right-uuid/ Does DBForge have the ability to set the UUID as V4 or V7 in the table builder ? If not, can we get
Changing any paramaters in a NEW unsaved stored procedure, cleaars all of the SQL code section
HI ! This is for DBForge studio 2025.1.134 It did the same thing in 1.124 as well. I thought I saw this posted already. I went looking for it but could not find it. so posting it here. If you create a new stored procedure, then go to the SQL code section
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
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
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
Feature Suggestions : DBForge MySQL - Table Template
HI ! I have an idea for a feature enhancement. (currently using 2025.1.124) We design many of our database tables with several of the identical fields. id int(11) NOT NULL AUTO_INCREMENT, DateUpdated datetime NOT NULL, IDUpdated int(11) NOT NULL, VisitorID
DBForge MySQL - BOOL fields converted to TinyINT(1) on their own
HI ! Not sure If this is a bug or a new feature. But I just noticed that ALL of my fields that I created as Boolean types, converted themselves to TinyInt(1). Every one of them in the entire database. This is 2025.1.124. Is this supposed to happen ?
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?
Query Builder overwrites my text and generates a query with errors?
dbForge Studio for MS SQL version 7.1.63 (Windows 11) Steps to Reproduce: 1. New Query 2. Add tables to the Query Builder 3. Give tables alias 4. Join on fields as needed 5. View text tab and qualify fields with alias (manually type them in) 6. Return
Feature Suggestions : DBForge MySQL - Table Designer SQL Direct Edit/Paste
As In my other post about how we design many tables with the same basic fields of data, It would be very nice to be able to open up a new table, create the fields we want, and then paste in directly in the SQL section a template of multiple fields. For
Cannot decrypt procedures on Azure SQL
I have the free Decryptor product and would like to use it on Azure SQL. Whenever I try, I get the error message "dbforge SQL encryptor DBCC command 'DBINFO' is not supported in this version of SQL Server." Is the decryptor compatible with Azure SQL.
DBForge MySQL - Linking Tables with FK shows up in random spots
HI! First time posting here, NEW User ! Whoo Hoo ! I just installed the latest of DBForge Studio for MySQL - 2025.1.124 I like the product. So far, I am very happy I noticed something though and wondering if this can be looked at and changed. When I create
ScFTPClient.Upload - Change the folder or file permissions on a web space
Is there a way to change the folder or file permissions on a web space to 755 or 644 using the ScFTPClient component ( sendcmd? ). Can you send me an example for C++ Builder XE4. Thank you.
SQL Complete No Longer Shows Column List For Trigger Tables
I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members CREATE TRIGGER [dbo].[tu_Contact_StandingId] ON [dbo].[Contact] AFTER UPDATE AS BEGIN IF UPDATE(StandingId) BEGIN INSERT CapitaTransaction
SQL Complete Support for Synapse/Serverless
We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
Upgrading SSIS Data flow for Salesforce Issue with License
Hello, We are using the SSIS data flow component 1.7.x for salesforce. It has been working for years. Now we have migrated servers (SQL2014=>SQL2019) and when deploying the SSIS Package and scheduling it to run using SQL Server agent we get "Cannot find
exec current statement for pl/sql bloc containing JSON_OBJECT cause error
hi, running this block via execute current statement cause error 1 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file"
Next Page