Insert records sqlite

Databases
1

I have to save records this is the syntax:
sqlinsert=“insert into database.Employees (‘firstn’,‘lastn’,‘address’) VALUES (‘one’,‘two’,‘five’);”
db.SQLExecute (sqlinsert)
Error: No such table: database.Employees
Question:
How to save the records…???

2

You’ll find some great examples in the docs.
http://documentation.xojo.com/index.php/SQLiteDatabase

The error suggests that your database does not have a table called “database.enployees”.

3

Thanks,
I’m going to check the link

4

Your table is probably just “employees”. Drop the “database.” prefix.

5

Hi Tim,

Thanks for the tip