Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foo = "1234..78.0"
- db:exec( "CREATE TABLE IF NOT EXISTS "
- "Pattern("
- "Idx INTEGER PRIMARY KEY AUTOINCREMENT,"
- "Strip TEXT,"
- "Startdigit INTEGER,"
- "Enddigit INTEGER,"
- "Value TEXT,"
- "Name TEXT,"
- "Message TEXT,"
- "Relatives BLOB"
- ")"
- )
- queries.newPattern:prepare("INSERT INTO Pattern(Strip, Startdigit, Enddigit, Value, Name, Message, Relatives) VALUES( (?) , (?) , (?) , (?) , (?) , (?) , (?) )")
- queries.newPattern:bind( idx , value ) -- binds value to (?) at (idx)th position
- queries.newPattern:lastError()
- db:exec("SELECT * FROM Pattern")
- "-1434302411"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement