 H.Brill | Hi, what Perhaps not everyone white, is, that one with SQL or. SQLITE too IN-MMEORY - Databases produce can. it'll hold no DB on disk (volume) created, separate only memory. as Abfallprodukt can so too, if too only terminable (simple XML-Structures) XML-Files produce. here time one small example for SQLITE :
Cls
Set("SQLFile", "F:\Test.xml")
' :memory:
var fbDLL& = db("slUseDLL", "F:\sqlite3.dll")
declare hdb&// lever the data base
hdb& = db("slInit", ":memory:")
Set("SQLFile", "F:\customers.xml")
db("slExec", hdb&, "ATTACH DATABASE ':memory:' AS Kunden", 0)
db("slExec", hdb&, "CREATE TABLE customers( FIRST NAME CHAR(25),NAME CHAR(25),GEBDAT CHAR(10))", 0)
db("slExec", hdb&, "INSERT INTO customers (First name,name,Gebdat) VALUES ('Hugo','Maier','10.02.1955')", 0)
db("slExec", hdb&, "INSERT INTO customers (First name,name,Gebdat) VALUES ('Erika','Maierbär','26.11.2000')", 0)
db("slExec", hdb&, "SELECT * FROM Kunden", 0)
db("slExec", hdb&, "SELECT * FROM Kunden", 2)
db("slDone", hdb&)
CLEARLIST
Move("FileToList", "F:\customers.xml")
Listbox$("XML-Datei", 2)
Print "Done..."
Waitkey
Please on The Paths respect. |
|