Basic question: _SQLite_Open ()

[fielmann]

Hi Folks,

#include <SQLite.au3>
#include <SQLite.dll.au3>

_SQLite_Startup ()
If @error > 0 Then
    MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!")
    Exit - 1
EndIf
_SQLite_Open (); Open a :memory: database
If @error > 0 Then
    MsgBox(16, "SQLite Error", "Can't Load Database!")
    Exit - 1
EndIf
_SQLite_Close ()
_SQLite_Shutdown ()

Basic question: Why should I open a database as a "memory database"?

When I close the database the content is lost <- correct ?!

[ChrisL]

Hi Folks,

#include <SQLite.au3>
#include <SQLite.dll.au3>

_SQLite_Startup ()
If @error > 0 Then
    MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!")
    Exit - 1
EndIf
_SQLite_Open (); Open a :memory: database
If @error > 0 Then
    MsgBox(16, "SQLite Error", "Can't Load Database!")
    Exit - 1
EndIf
_SQLite_Close ()
_SQLite_Shutdown ()

Basic question: Why should I open a database as a "memory database"?

When I close the database the content is lost <- correct ?!

Yes all the content is lost when you close it.

You might want to temporarily store a load of data and use an SQL query to sort the information out for what you need but you might not be interested in retaining the data after you have used it

[KaFu]

Because it's much faster than a file database... for saving the contents take a look at my signature , i wrote a UDF for that. For re-loading the content take a look at the source of SMF (I'm too lazy now to look up the function).

Best Regards