Recent Topics
Why no active back button after a failed data import?
After an import fails for whatever reason in the Import Data option, the back button is always disabled. I can only click on the Finish button and it takes me out. This means I have to start all over again and repeat this workflow until there are no more
Importing fixed width flat file should default to the columns and their sizes in the destination table
I am trying to import a flat file with fixed width columns. I created beforehand a table to accept this data and defined the columns with sizes that match the field size to be imported, in the import wizard I had to manually define all the positions and
dotConnect MySQL Info
2 questions with the dotConnect for MySqL 1) does dotConnect for sql work with the square brackets in mySQL? The devArt MySQL Odbc driver handles the square brackets but it looks like the [] are throwing an error? Example select * from [Company] 2) using
dbExpress very slow on one computer
Hi All, Normally I have no problem with the speed of the dbExpress drivers. But I have one customer where the connection to the database (MSSQL) is very slow (more than 10 times slower than others). He has the same setup as others, so I cannot pin point
Migratig from FibPlus
Hi I have a FibDataSet with CachedUpdate activated. and this code: Trans := Consulta.Transaction; Trans.Active := true; Consulta.Open; Trans.Active := false; when I close the transaction, the DataSet state is dsBrowse and all the data are still in DataSet.
Multiple dataset problem
Hi, I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical
How to move to a new computer?
I need to move the QuickBooks ODBC driver to a new computer. What is the process to do that?
SQL Complete - Can the code snippet auto-complete function be customized with a key other than 'Tab'?
Dear Devart, Hello. I am a user who is considering using sql complete this time. I asked you a question about using Code snippet in SQL Complete. As a result of checking the manual, it is confirmed that the snippet is automatically completed if you enter
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'
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
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
Next Page