Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <SQLite.au3> ;SQLite Funktions include
- #include <SQLite.dll.au3> ; die SQLite dll
- _SQLite_Startup() ;SQLite initialisieren
- $hDatabase = _SQLite_Open(@ScriptDir & "\TestDatenbank.sqlite") ;eine neue datenbank erstellen
- _SQLite_Exec($hDatabase,"CREATE TABLE `TestTabelle`(`Name` TEXT,`ID` INTERGER)") ; eine Tabelle einfügen Name|ID
- Dim $aNamen [9] = ["Peter","Ramona","Michael","Rolf","Hans","Petra","Felix","Dominik","Steven"] ;Eine Array mit Namen
- For $x = 0 To UBound($aNamen) -1
- $sSQL = "INSERT INTO `TestTabelle`(`Name`,`ID`) VALUES ('%s',%s)" ; Daten Hinzufügen SQL
- $sSQL = StringFormat($sSQL,$aNamen[$x],$x+1)
- _SQLite_Exec($hDatabase,$sSQL) ;<-- hier kommen die Daten in die Datenbank
- Next
- _SQLite_Close($hDatabase) ;Datenbank schließen
- _SQLite_Shutdown(); sqlite herunterfahren
Advertisement
Add Comment
Please, Sign In to add comment