Sprenger120

SQLite Beispiel

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