Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2015
225
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. foo = "1234..78.0"
  2.  
  3. db:exec( "CREATE TABLE IF NOT EXISTS "
  4. "Pattern("
  5. "Idx INTEGER PRIMARY KEY AUTOINCREMENT,"
  6. "Strip TEXT,"
  7. "Startdigit INTEGER,"
  8. "Enddigit INTEGER,"
  9. "Value TEXT,"
  10. "Name TEXT,"
  11. "Message TEXT,"
  12. "Relatives BLOB"
  13. ")"
  14. )
  15.  
  16. queries.newPattern:prepare("INSERT INTO Pattern(Strip, Startdigit, Enddigit, Value, Name, Message, Relatives) VALUES( (?) , (?) , (?) , (?) , (?) , (?) , (?) )")
  17.  
  18. queries.newPattern:bind( idx , value ) -- binds value to (?) at (idx)th position
  19.  
  20. queries.newPattern:lastError()
  21.  
  22. db:exec("SELECT * FROM Pattern")
  23.  
  24. "-1434302411"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement