Jump to content

simple sqlite db manager


ldb68

Recommended Posts

As for the ADO sample I made a simple sql manager for sqlite database.

Sqlite is a very fast embedded database (I get 60000 insert / second on table in test database attached).

Attached also sikav3 vcl for sqlite database.

Search google for complete sikav3 package with demo (has a simple desktop db manager).

AjaxSqlite.zip

  • Upvote 1
Link to comment
Share on other sites

  • 1 month later...

I can not compiled with Delphi XE2.When I compiling SivakSQLite3.dpk in IDE, it gives following error: :o

 

AjaxSqlite\sivak3\sql3_utils.pas(220,28): warning W1057: W1057 Implicit string cast from 'AnsiString' to 'string'
AjaxSqlite\sivak3\sql3_utils.pas(227,31): warning W1057: W1057 Implicit string cast from 'AnsiString' to 'string'
AjaxSqlite\sivak3\sql3_defs.pas(441,1): error E2037: E2037 Declaration of 'FreeRecordBuffer' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(442,1): error E2037: E2037 Declaration of 'ClearCalcFields' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(446,1): error E2138: E2137 Method 'GetBookmarkData' not found in base class
AjaxSqlite\sivak3\sql3_defs.pas(447,1): error E2037: E2037 Declaration of 'SetBookmarkFlag' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(448,1): error E2138: E2137 Method 'SetBookmarkData' not found in base class
AjaxSqlite\sivak3\sql3_defs.pas(462,1): error E2037: E2037 Declaration of 'InternalInitRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(465,1): error E2037: E2037 Declaration of 'InternalSetToRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(467,1): error E2037: E2037 Declaration of 'AllocRecordBuffer' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(471,1): error E2037: E2037 Declaration of 'GetBookmarkFlag' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(472,1): error E2037: E2037 Declaration of 'GetRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(490,1): error E2037: E2037 Declaration of 'GetCurrentRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(686,18): error F2063: F2063 Could not compile used unit 'sql3_utils.pas'

Link to comment
Share on other sites

  • 4 weeks later...

Author of SivakSQlite3 has not yet released a Delphi XE2 compatible version.

See it at:

 

http://www.filedepot.eu/

 

 

I can not compiled with Delphi XE2.When I compiling SivakSQLite3.dpk in IDE, it gives following error: :o

 

AjaxSqlite\sivak3\sql3_utils.pas(220,28): warning W1057: W1057 Implicit string cast from 'AnsiString' to 'string'
AjaxSqlite\sivak3\sql3_utils.pas(227,31): warning W1057: W1057 Implicit string cast from 'AnsiString' to 'string'
AjaxSqlite\sivak3\sql3_defs.pas(441,1): error E2037: E2037 Declaration of 'FreeRecordBuffer' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(442,1): error E2037: E2037 Declaration of 'ClearCalcFields' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(446,1): error E2138: E2137 Method 'GetBookmarkData' not found in base class
AjaxSqlite\sivak3\sql3_defs.pas(447,1): error E2037: E2037 Declaration of 'SetBookmarkFlag' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(448,1): error E2138: E2137 Method 'SetBookmarkData' not found in base class
AjaxSqlite\sivak3\sql3_defs.pas(462,1): error E2037: E2037 Declaration of 'InternalInitRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(465,1): error E2037: E2037 Declaration of 'InternalSetToRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(467,1): error E2037: E2037 Declaration of 'AllocRecordBuffer' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(471,1): error E2037: E2037 Declaration of 'GetBookmarkFlag' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(472,1): error E2037: E2037 Declaration of 'GetRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(490,1): error E2037: E2037 Declaration of 'GetCurrentRecord' differs from previous declaration
AjaxSqlite\sivak3\sql3_defs.pas(686,18): error F2063: F2063 Could not compile used unit 'sql3_utils.pas'

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...