Reference example use ADO to connect the SQLite database online, want to use SQL statements to create memory database and attached to the original database, but no, hope ace to give a hand, thank you first!
Want an example of this: ADOQuery1. SQL. ADD ('... '); ,
Why use SQLite, as everybody knows, Access database, with the like query, always prompt "out of memory", try the SQLite does not exist the problem, so I want to use SQLite, why use memory database, because every time insert the tens of thousands of records, slowly, try the SQLite, speed can increase 5 times,
Looking forward to master,

CodePudding user response:

SQLITE seems to be something to convert UTF,,,

CodePudding user response:

I am a mixture of ADO and SQLiteTable3, so feel uncomfortable
If only use ADO don't know how to build an in-memory database, if only use SQLiteTable3, there is the code, like SQLiteTable3 add or insert data can only use the insert (not append, post, etc), insert statement is very difficult to write, for example, I use ' ' '+ STR +' ' 'this form, if the STR in' for dinner? Insert, looks out of the question,

CodePudding user response:

What is SQLiteTable3 components? Delphi?
Sqlite is created when the database is to determine physical or memory, you see are the components you use this option

CodePudding user response:

You is how to use Ado to connect Sqlite, is VC

CodePudding user response:

Using ODBC to use ADO can easily connect the SQLite database, you first need to install SQLite ODBC Driver,
Here is an example: online
http://blog.csdn.net/zyq5945/article/details/6457741

CodePudding user response:

Directly using the sqlite DLL API

CodePudding user response:

Can directly use the dataSet based memory table,

CodePudding user response:

Sqlite access access can use UniDAC, pretty good