English
SDK-aide/ Tools

SQLite Return with slExec, X4, with Testprogamm (too for Beginner)

IN-MEMORY - DB

 

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.
 
Benutze XPROFAN X3 + FREEPROFAN
Wir sind die XProfaner.
Sie werden von uns assimiliert.
Widerstand ist zwecklos!
Wir werden alle ihre Funktionen und Algorithmen den unseren hinzufügen.

Was die Borg können, können wir schon lange.
04/12/23  
 



Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

756 Views

Untitledvor 0 min.
Matzbub02/03/24
Thomas Zielinski06/28/23
Paul Glatz06/22/23
E.T.06/12/23
More...

Themeninformationen

this Topic has 1 subscriber:

H.Brill (1x)


Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie