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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...