Devart Forums

Hi Alex,

I have forwarded the email I sent you to the support email id that you menioned. My email id is [email protected]. Please check with the support team for emails from this email id.

Thanks,
Balaji R

Hi Alex,

My colleague (Roy Randazza) and I (Balaji) had emailed ([email protected]) you for the nightly build that you said you will share. Could you please send the build to Mr Roy? If "[email protected]" is incorrect email id, pleaes let us know the correct one.

Also please let us know when you plan to release the build with this fix.

Thanks,
Balaji R

Hi All,

I get an error message "TDBXError with message T4" when connecting to SQLServer database using TSQLConnection and DevArt DBExpress driver for SQLite. Can anyone tell what this message means?

Thanks,
Balaji R

Hi,

Could you please tell me when the next version is expected to be available? We can plan to go with current approach or use some other approach based on the timing of this fix.

Thanks,
Balaji R

Thanks. We are considering the use of direct connection to sqlite Db for an upcoming release.
Please let us know as early as you can as to whether this can be fixed.

Thanks,
Balaji R

Hi,

Thanks for the reply.

The error is thrown if I compile your code as 64 bit application. 32 bit works fine. I use Delphi XE7 and Windows 8.1.

Thanks,
Balaji R

Hi,

When trying to use the Direct sqlite connection from DevArt sqlite driver, I observed the following.

1. 'Local time unavailable' Error: I get the mentioned error message when trying to insert a record in to a table which has a trigger that uses the datetime('now','localtime') function from sqlite. From the application I try to insert values for one integer column alone and I expect the trigger to update the datetime value for the other column in the table.
This used to work when we connected using the sqlite3.dll and dbexpsqlite40.dll previously.
I couldn't test it with latest drivers since I dont' have 64 bit sqlite3.dll. Also, when I directly insert data in to the table for the column 'a' alone from sqlite command prompt it works. Is this a bug in driver?

In the following link
http://www.devart.com/dbx/sqlite/revision_history.html

I can see some bug fix related to datetime in an older version, is this fixed, is this what I am experiencing? I am using 3.6.9 version of the drivers.

3.3.4 21-Oct-13

Rad Studio XE5 is supported
Now the Direct mode driver is based on the SQLite engine version 3.8.0.2
The 'True' Boolean value is now saved in the database as 1
Bug with retrieving indexes is fixed
Bug with an incorrect datetime (date, 'localtime') function result in the Direct mode driver is fixed
Bug with detecting auto-increment fields is fixed



CREATE TABLE TestDatetime(a integer, b datetime);
CREATE TRIGGER TestDatetime_insert after insert on TestDatetime
for each row
begin
update TestDatetime set b = datetime('now', 'localtime');
end;


2. Is it necessary to provide the dbexpsqlite40.dll path when using 'Direct Connection' or including the unit name 'DBXDevartSQlite' and specifying the dcu path for 'DBXDevArtSqlite' and other dcus sufficient ?

3. Where can I find additional information regarding the drivers and its sample code?

Thanks,
Balaji R

Thanks for the confirmation.

Hi,

Could you please confirm "Statically linking" sqlite dbexpress driver, without using sqlite3.dll, to the sqlite database as mentioned in the devart website is same as the following code "Direct Connection" mentioned in the Readme for the driver or is it different. If it is not, could you please provide a sampel code for that?

For Direct connection:

SQLConnection.ConnectionName := 'Devart SQLite Direct';
SQLConnection.DriverName := 'DevartSQLiteDirect';
SQLConnection.LibraryName := <library name>; // <library name> depends on your IDE version. See the table below.
SQLConnection.GetDriverFunc := 'getSQLDriverSQLiteDirect';
SQLConnection.Params.Clear;
SQLConnection.Params.Add('Database=MyDatabase');
SQLConnection.Open;

Thanks,
Balaji R