Recent Topics
Data Export - All Floats Become "General"
I'm using dbForget Studio for PostgreSQL Professional Edition v. 3.1.618. When I use the data export tool, all floating point numbers in all output formats simply become the word "General" - no numbers; just the word. Anyone see that before? I tried restarting
Minor visual issue in data comparison
Data comparison, Mapping tab. Pressing ... on a table which has a comparison key, opens the mapping window. In there, see the problem portrayed in the image attached to this post.
WooCommerce connection to the ODBC driver
I want to control the data on my WooCommerce site using Microsoft Access. I installed the OCDB driver and I don't understand how to proceed further. I guess I know how to connect Access to the driver, but I don't understand how to connect the driver to
Is it possible to add a report to a data syncronization?
I am currently working on a project in which I am using the script of the following article to synchronize two databases: Compare Two Database Schema in SQL Server on a Schedule (devart.com) I was looking for more articles and I found this second article
Is it possible to connect to oceanbase?
I got a error message by test connection "Unknown table 'PLUGINS' in information_schema (code 1109)"
Source Control Conflicts - Grants added on end
Hello, When running source control some tables, procedures etc. are flagged as conflicting. Clicking get local/remote does nothing as they seem to come back on refresh. The conflict seems to be grant permissions being added on my local database (automatically)
Query taking much longer in Direct Mode than when using an Oracle client
Hello, Our product gives the user a choice of using either Direct Mode or using an Oracle client. A customer has reported that when using Direct Mode, a particular query is taking 17 minutes, and when using an Oracle client, it takes only 18 seconds.
TScMailMessage adds In-Reply-To if Message-ID exists
Hi, As far as I know In-Reply-To header should be used in replies. Now If I add Message-ID to specialheaders it also copies it's value to In-Reply-To header In ScMailMessage.pas procedure GenerateHeader there is piece of code.. if FHeaders.Names['In-Reply-To']
Memory not released after closing TSmartQuery with LOBs
Hello, Regarding this issue, created about 1.5 years ago on the old forum: https://forums.devart.com/viewtopic.php?f=5&t=44418 Your latest answer is: We have reported it to Oracle but have not gotten an answer from them. Can you ask again? Have
Linq Connect Update Timeline
Is there a timeline for an update to LinqConnect 5.-0.151 to support the recent updates to visual studio? Thanks -Pete
How to determine which version of dotConnect for Oracle is being used?
Hello, let me first give you my context as succinctly as possible. Our .Net Framework application uses dotConnect for Oracle NuGet package 9.X.X. When I joined the team and started developing for the app, I realized that certain queries took extremely
[bug] auto-where by RefreshRecord (v8.0.0)
auto-where by refreshrecord works incorrectly with: cross join SELECT bdea.dbrid ba_op FROM bdea CROSS JOIN ab2 WHERE ba_ix = :ab_ix :ab_ix(WideString[3])='100' WHERE ( ba_ix = :ab_ix) AND cross.dbrid = :ba_op :ab_ix(WideString[3])='100' :ba_op(WideString[3])='136'
Exception "The CRL is not found"
Hello, we are using SecureBridge 10.0.1 for Delphi. A few days ago, on some Clients the function WebRequest.GetResponse.ReadAsString raises an exception "The CRL is not found". On other clients the function works fine. Da you have any idea, how to fix
change SQLwait cursor when autorefresh
hi Some of the TMyQuery have Autorefresh enabled. When the autorefresh is executed the cursor changes automaticly to crSQLWait. Is it possible the changes this into the crDefault so the user does not sees the crSQLWait cursor. OR Is it better to use a
Can't install LINQ Insight, error reports Visual Studio not installed
Hello, I have downloaded a trial version of LINQ Insight for evaluation from your website. When I launch the installation I get the following message, despite having Visual Studio 2022 installed. Is this product not compatible with this version of Visual
Wrong display/update of TIMESTAMP WITH TIMEZONE data in diect mode
For demo, PLS create a table CREATE TABLE TS_TEST ( ID NUMBER (9,0) NOT NULL, TS TIMESTAMP(6), TS_TZ TIMESTAMP(6) WITH TIME ZONE, TS_L_TZ TIMESTAMP(6) WITH LOCAL TIME ZONE ); ALTER TABLE TS_TEST ADD ( CONSTRAINT "_PK" PRIMARY KEY ( ID ) ); And insert
dbexpida.dll version 6.1.0 fro FirebirdSQL
Afert change dbexpida.dll 6.0.4.0 to 6.1.0.0 in some situation I get EListError in module dbexpida.dll at 0001ab0e List index out of bounds(4) This is raise in method function TCustomSQLDataSet.GetFieldData(FieldNo: Integer; Buffer: Pointer): Boolean;
When using TScHubConnection in dll, the main window closes and gets stuck.
I use TScHubConnection in the dll loaded by the exe to connect to the server. When the exe is closed, the window freezes directly and the process must be forced to end. I tried modifying the EventsCallMode, all modes have no effect. Help!
ODAC Pooling
Hi, Greetings! I'm trying to use ODAC connection pool feature, but im having a hard time figuring out how it works. Is there any demo or sample project that shows how it's done? Thanks in advance Rogerio
[10.0.60 ENT] unable to export to google sheet if auth failed
hi devart, when i authrorized dbforge for google account A) and later on I need to export data to a sheet that is connected to a different account B), I have no choice. instead of this error, dbforge should ask to "re-authenticate". unable to do that,
Oracle Advanced Queuing - OracleQueue.Dequeue
OracleQueue.Dequeue only returns the first message. In my test I enqueue 20 messages, and only the first one gets dequeued. I have no idea why.
Renamed Tables in Schema Comparison
I have several tables in my database with the names changed. Using the Schema comparison, the suggested strategy is to DROP the table and create the new one empty, but this will generate a data loss. How to "explain" to the Schema comparison tool that
Can't Set the Text Color
Hi. I just reinstalled dbForge Studio on a new machine without backing up my old settings. I had the Visual Studio Dark skin before with readable white colored text in the code editor. Now that I have installed this slightly newer version on my new machine
Possible OraClasses bug?
Hi, During a test, I've had a range check error throw up in OraClasses.pas. It was in version 12.2, but I've just updated now to 12.3 and I think the problem is the newer version as well. I am currently unable to reproduce the error, but I think it had
Adding an TActivityindicator when running long queries. What is the best way to implement?
Some of my queries with Unidaq (Locates, field lookups and updates) take a few seconds to implement. What is the best way to implement an activity indicator when these are initiated? Can I use events to kick off showing, displaying, updating, and eventually
Does DotConnect Universal also support Net 7 ?
Hi, I saw that with Build 134 DotConnect Support Net 7. Does this also includes DotConnect Universal ? I only found information for the individual Daztabases. Thanks and regards Uwe
Doesn DotConnect Universal support Net7
Hi, does DotConnect Universal already support Net 7. I get the following Error Message when I try to open a database: System.MissingMethodException: "Method not found: 'System.String System.AppDomainSetup.get_LicenseFile()'." I am using the SQLiteCrypt
You have problems with version v10? Here's your solution!
step 1 step 2: enjoy going away the pain step 3: bring back peace to your daily work FINAL WORDS I'm tired of playing guinea pig and spending my time making stupid bug videos and closing 100,000 tabs every day, I'm just tired of this shit! I'll use version
importing data from SQLite to excel, changing data and then exporting back to a different table in SQLite
Hi i am trying to find out how to import data from SQLite into excel using Devart excel add-in, change the data and then export the results back into different table in SQLite. Any help would be greatly appreciated regards John
Using INTEGER PRIMARY KEY as 64 bit identity
I am using LiteDac 5.0.1 with Delphi 2007 and I am trying to use an auto-incrementing primary key defined as INTEGER PRIMARY KEY. The field takes values much larger than MaxInt but when I try to read the data in with a tLiteQuery it thinks the field is
UniScript and specific SELECT script won't work
Hi, I use Uniscript with Interbase 7, and with this particular script, nothing append on the DB : SELECT GEN_ID( my_gen, MAX(id) - GEN_ID(my_gen, 0)) FROM my_table; (The generator my_gen should have taken the max value of my_table.ID). And no error were
TMSTable.post problem: Operation Aborted. How to get more detailed information ?
Hello, Using an TMSTable with 82 fields, and 1 keyfield (integer), I'm able to Insert, Delete and Edit, but when I execute Post, the operation fails with exception: Operation Aborted and no further information. If I delete the record and then Insert,
Issue with Inserting Current Time Using Now Function in Timestamp Column in Delphi 12 and UniDac 10.0.0
I have a problem with compiling in Delphi 12 with UniDAC 10.0.0. Everything works in Delphi 11 with UniDac 9.4.0. Database is Postgres. When I want to insert the current time into a table item that is of the timestamp type using the Now function, an error
PYODBC sample code for Devart & QuickBooks Online
I am just starting to work with Devart (moving from QODBC). I am using PYODBC with Python and QBO. I am looking for some sample code for queries particularly journal entries. Surely someone else besides me is doing this, but I am not able to find any
BLOB With VirutalQuery Oracle
Hi, I need to use VitrualQuery to transfert Tables, table with clob et blob, but if I done the folowing code. With Postgres at the end Table2.Memo is filled by with Oracle is Empty. If I execute 'INSERT INTO TABLE2 SELECT * FROM TABLE1' in sqlplus it
Amazon Redshift ENCODE issue
Redshift tables DDL generation Note: ENCODE encoding The compression encoding for a column. ENCODE AUTO is the default for tables. Amazon Redshift automatically manages compression encoding for all columns in the table. If you specify compression encoding
Cant connect to my MySQL
I am absolutly doing something wrong, but i cant connect to my MySQL with "dbForge Query Builder for MySQL" or its impossible to connect to small server like 'USB Webserver'? Its get me error 1146
Running Report Created by dbForge Studio for SQL Server in different environments
I created report using dbForge Studio for SQL Server on development server. How can I run the same report on testing server. Both development and testing servers have the same exact structures, just different data.
dbExpress 6.1.0 possible regression
Hello, After updating our Delphi 11.3 application from the 6.0.3 of dbExpress to 6.1.0 for Firebird (v. 4.0.4) a problem occurred: Sample code: Query.SQL.Text := 'select * from TableX order by KeyField'; Query.Open; Query.First; // not needed; only for
Delphi 12 components
Hello, Delphi 12 has been out for 3 days and I see that it is not possible to download SDAC components for this new version. When can I expect components for version 12 ? I'm a bit surprised that there are no components on the same day that Delphi comes
Next Page