Recent Topics
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"
How to compile a db object loaded from a file?
I can't find any documentation on how to use DB Forge Studio for Oracle to load a package spec and body from a file on my PC and then compile it. It only seems possible to create them from scratch or to edit existing objects. My team keeps all of our
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
[FEATURE REQUEST] Add Chat-GPT to the Editor !
hey devart team, if you make this possible, i guess all people will say only one thing to you:
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
create new database,user
Hello, i download dBforge studio for postgres and try to create database, table or user but there is no option for that as Mysql tool. so i missed something or it is limitation in this product? if it is limitation, are you going to develop it so that
Salesforce ODBC - null-able columns marked as not null?
Your ODBC driver reports some columns as not null-able and then sends rows containing null values for them: Calendar.Name DuplicateRule.Language EntityDefinition.LastModifiedById FeedComment.HasEntityLinks FlowDefinitionView.LastModifiedDate Folder.Name
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)))
Error: "Invalid parameter "
Hello. I'm using the SQL-Server dbExpress, version 9.3 with Delphi Athens. On my development computer the connection with the database is workink perfectly. However, when I tryed to execute the application in a different computer I get this error message
Unidaq Provider for NexusDB Embedded in Delphi 12.3
I'm trying to use UniDaq in Delphi12.3 to connect to an embedded NexusDB. I followed the instructions and recompiled nexusprovider290.bpk, which created a new nexusprovider290.bpl file in the ${DELPHICOMMONDIR}\Bpl folder, which is included in the path
LinqConnect - change database at runtime keeping a single connection
Hi, I am testing a trial version of LinqConnect. I have a bunch of databases which all have the same table structures. In EF Core, I can create one DbContext and easily switch between the databases using ChangeDatabase: MyDbContext.Database.GetDbConnection().ChangeDatabase(<MyDatabase>);
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.
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),
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...
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
Next Page