Recent Topics
GetDate() error for Dynamics ODBC Driver
I'm getting an error message when I use GetDate() in a SQL query I'm writing using the ODBC driver. Basically I only want to pull records created today. Has anyone run into this issue and found a work around? Thanks
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
ItemInventory missing custom fields in QuickBooks Desktop
I'm trying to select from ItemInventory with a python script and I'm finding that the table structure is different, when I use the DevArt driver rather than the QODBC driver. Particularly, the custom fields are missing. I'm not seeing any settings in
SocketException with dotConnect for Magento while Opening Connection
Hello, I am experiencing a Socket connection error with ADO.NET provider for dotConnect for Magento while opening a connection. Interestingly there is no problem connecting to the database with MySQL Nuget package by Oracle. The Connection Errors are:
I can't use UniDac in Linux application.
Hi everyone. I have a REST application in Delphi Athens 12, in Windows works very well (connected to PostgreSQL 14 in Ubuntu 22.04 64bits). I make the same application to Ubuntu 22.04 64bits (Target plataform), the application starts well, but in the
Color schema for matching brackets like in Azure Data Studio
Is there an option (or is it at least planned) in dbForge Studio for SQL Server to use different colors for matching brackets like in Azure Data Studio?
Security Banners
From https://www.devart.com/odac/revision_history.html.... Added support for connect to servers with enabled Security Banners in the Direct mode Hello, Can you provide some details on this? I would like to be able to display the banners in my application,
How to configure automatic formatting of function words in a text editor?
Hi, dbForge Studio for MySQL v.10.0.150 There is a problem with the word "SET" . How can i customize text editor to print this word in upper case automatically? The parameter "Automatically format words while typing" is on. I print SET in upper case mannualy,
[10.0.46] run a second query (by hotkey) in the same editor does not work (without hitting the hotkey twice)
hi devart, i do hope this is a bug and not another great example of "industrial standards". if you have a regular edit tab open and have a query there that you can run with the hotkey that runs a query where the cursor is - and you write a 2nd query and
additional quotes when copying from the data editor
v.10.0.60 example SELECT JSON_OBJECT("key1", 'val1', "key2", 'val2') UNION SELECT JSON_OBJECT("key3", 3, "key4", 4); 1. when copying a value from one line everything is ok 2. When you copy several lines, additional quotes are inserted
Type mismatch for SBadTimeZoneID
The second Parameter in the string SBadTimeZoneID (= 'Invalid Time Zone ID: (%d, %d)' ) is of type decimal. In the unit IBCCall.pas, the function TTimeZoneUtils.TimeZoneIDToTimeZoneName(...): String contains the line RaiseError(Format(SBadTimeZoneID,
TUniConnection.AssignConnect(TOraSession) ?
Hi, is there any way to assign an active TOraSession to a TUniConnection instance? There is a need to use both components with the same session.
Add Stored Procedure fails in DB First, unless trivial contents
Firstly, there seems to be no Support Category for Entity Developer. I hope that's not a reflection of the support for that product?? Most of the time when I attempt to add existing Stored Procedures to the model, the process fails when retrieving result
Debugger failed with timeout
hi. I have problem with "step into" while debug code : "Debugger failed with timeout" What's wrong ? Thank you.
code completion for procedure parameters
Hi. code completion for procedure parameters don't work ( dbForge Studio 2024 for Oracle v. 4.6.15 refresh suggestions, ctrl+space does not help also sometimes in some sessions code completions stops working completely ( Thank you.
what grants required for "Navigate to definition" ?
Hi, i have had error while trying to "Navigate to definition" what grants required for "Navigate to definition" ? and are they necessary ? Another IDE successfully perform operation like this under the same user . You should understand that not all users
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
ORA-00918: column ambiguously defined for paging mode (
hi, i got error while getting next page of query result. for first page i have warning - it's Ok. but for next page i have ERROR 1 ORA-00918: column ambiguously defined SQL3.sql 3 8 Yes, i really have repeating column names, but without paging or for
ODBC Driver for BigCommerce
We are currently evaluating the ODBC driver for BigCommerce 2.4. Our products table in BigCommerce Enterprise has 500,000+ records and would like to query it. We are using a criteria in our query to display 1 product or 1 SKU but it doesn't show up (or
How does IBDAC handle RETURNING in Firebird 5 if there is more than an row returned?
https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-compat-returning says: Client-side INSERT … SELECT, UPDATE, DELETE, MERGE and UPDATE OR INSERT queries containing the RETURNING clause may now return multiple
UniDAC: SQLite extension error
Im trying add pivot table extension "pivot_vtab" (https://antonz.org/sqlite-pivot-table/) to my sqlite, according to item "3. Pivot extension" in manual. I compiled DLL, in UniConnection did load an extension, see manual here: https://docs.devart.com/unidac/using-sqlite.htm.
TScSFTPClient: Append file on server in new line
Hello, TLDR: How do I properly append a file on server in a new line using TScSFTPClient? I replaced my Indy-FTP-Clients with SecureBridge and I am currently working on an instance in which a textfile on a server is appended with the data of a local text
Connecting to PostgreSQL or MSSQL Using Oracle Database Link and ODBC Driver
I want to connect PostgreSQl and MSSQL in Oracle using dblink. I do everything from this page https://docs.devart.com/odbc/postgresql/oracle_dblink.htm and it doesn't work. Please help
Foreign Key violation with 11.0.0
I recently updated SDAC to 11.0.0 (Delphi 7) and made a few tests and all seemed ok. This morning I had an Issue arise with a migration application, The main difference with this is the application connects to two MSSQL databases and allows our customer
Concurrency violation when updating SQLite database using DevArt ODBC Driver
Hi, I'm trying to debug errors produced when updating an SQLite database using the DevArt ODBC Driver from a Win32 application. I'm using COM/MSADO in C++ to interface with the Microsoft OLE DB Provider for ODBC Drivers, which in turn uses the DevArt
Strange behavior when opening and saving documents to OneDrive
I have dbForge Studio 2022 for Oracle PE v4.4.64. At my work, I save all my work in OneDrive. For years I have become used to a behavior where, a few seconds after saving a file, I am prompted like this: I assume some file properties were in motion while
This server version 8.0.36 is not currently
dbforge version : dbForge Studio for MySQL Enterprise 9.0.338.0 mysql version：8.0.36 connect error：This server version 8.0.36 is not currently
ODBC Driver for SQL Server with DBExpress
I Want to know if it is possible to work with the ODBC Driver for SQL Server using dbexpress connection with Devart drive ? and how should I configure tha parameters connections ?
Remove Transaction
Hello, i am creating at runtime a update transaction based on the edit form : Var FUpTrans: TIBCTransaction; procedure OnFormCreate; begin FUpTrans:= TIBCTransaction.Create(AOwner); <-- AOwner = Form FUpTrans.Active := False; FUpTrans.DefaultCloseAction
IBCQuery1.LoadFromXML(File)
Hello Devart Team, All is on the Title. I need this scenario : 1. Saving data to an XML File : IBCQuery1.SaveToXML(aFile); 2. Retreiving these Data from this aFile, something like : IBCQuery2.LoadFromXML(aFile); As IBCQuery.LoadFromXML does'nt exists,
Proxy connections in Direct Mode
Hello, I know that proxy connections are not supported in Direct mode. My question is - will they ever be? Is this something on your to-do list, or is there some reason that this is not possible? Thank you. John Dorlon
Code debuging
Hi, where is debug menu items ? Thank you.
CRDBGRID Number format of summary row
Hello, does anyone know how i can set the number firmat in th tcrdbgrid summary row? I use this grid as a generic SQL table view. In the programme the displayformat of each field is set (floating and integer). The grid will show me the values. But right
Magento ODBC Driver with Filemaker
I am trying to use the Magento ODBC driver with Filemaker, but this is totally useless. My first try was the category DB which has something like 100 records. And this worked fine, after about 10 seconds the table was available. Of course that is still
Support Fastreport 2024.1
Can you add Support for Fastreport 2024.1 to use the FastqueryBuilder. In FastReport are come Changes and it will be fine to use ther frxUnidac Component with the QueryBuilder.
ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel on this platform.
Guys, I'm trying to install the "Python Connector for ASE 1.0 - Python 3.7 for Linux" library on Linux and I ended up coming across the following message: ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel
Problem with Firebird ODBC on Ubuntu
After setup and running isql -v DEVART_FIREBIRD I get: [S1000][unixODBC][Devart][ODBC][Firebird]Cannot load library: libcrypt.so [ISQL]ERROR: Could not SQLConnect Here is my setup [ODBC Data Sources] DEVART_FIREBIRD=Devart ODBC Driver for Firebird [DEVART_FIREBIRD]
VirtualQuery To_Date
Hi, I need to write query in VirtualQuery with To_Date syntax what is the correct way to do it, what is the engine behind VitrualQuery ? Thanks.
Suggestion: add "Encoding" parameter to TIBCScript.ExecuteFile()
Hi, my database is all UTF8. If I load a script in UTF8 format(*) using TIBCScript.ExecuteFile(), all german "umlauts" are scrambled. Funny enough, if I set "UseUnicode" option of TIBCConnection to FALSE, then it loads correct. But then all other inserts
Find and replace dialog - look in All open documents
Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.
Next Page