ok, we'll waiting your SqlitePass_0.41. now, we'll trying to test the stability of that component/lib with indy9, borland socket, or ASTA 3.1 (for data transport from clients to application server with embedded SqliteDB)).
thanks for all.
1 2009-01-08 15:45:34
Re: missing to convert sqlite DateTime with SqlitePass_0.40? in delphi 7.1 (7 replies, posted in Bug Solved)
2 2009-01-06 20:45:37
Re: missing to convert sqlite DateTime with SqlitePass_0.40? in delphi 7.1 (7 replies, posted in Bug Solved)
adding explanation ... database opening with SqliteToolbox, the datatype is DateTime ..
missing conversion example ... in OrderDate field (original date is 04-07-1996) .. with SqlitePass_0.40 or SqliteToolbox (date is 05-07-0097)
we use ShortDateFormat := 'dd-mm-yyyy';
3 2009-01-06 20:11:24
Re: missing to convert sqlite DateTime with SqlitePass_0.40? in delphi 7.1 (7 replies, posted in Bug Solved)
sorry i don't have SqliteToolbox .. with the same database ... we try open orders table with lazarus IDE or Sqlite3Explorer or sqlite expert professional ... is correct.
my experiment to build multi-tier application sample with delphi 7, Indy9 (Internet Direct 9), SqlitePass_0.40, SqliteDB v3.6.7, and RemObject Pascal Script (for create an stored procedure sample) ... SqlitePass_0.40 have more speed and simple than Sqlite Components (from aducom) or ZeosDBO v6.6.4 (from Zeos)
where and how i can upload my database sample? ... thanks for your attention.
4 2009-01-04 18:05:19
Topic: missing to convert sqlite DateTime with SqlitePass_0.40? in delphi 7.1 (7 replies, posted in Bug Solved)
we try to convert Northwind Access Database, specificaly orders table with sqlite expert professional .. with no problem, but if we access that orders table with SqlitePass_0.40 in a form ... why the Date in the OrderDate, RequiredDate, and ShippedDate not the same with the original data ..... any suggest for this problem ?... thx.