two open databases

[Dermot]

Corect me if i'm wrong...
Where "Table_Name" = messages (field1,field2) are for... and VALUES(Val1, Val2...) are for...

Thx

Assuming your table is named "messages" and that table has one field named "message", this is how it would look

local msg = "This is your message"
"INSERT IGNORE INTO messages (message) VALUES('"..msg.."')"

[Bruce]

INSERT IGNORE INTO Table_Name (Field1, Field2...) VALUES(Val1, Val2...)

Corect me if i'm wrong...
Where "Table_Name" = messages (field1,field2) are for... and VALUES(Val1, Val2...) are for...

Thx

[Dermot]

LOL man I am LOST!
Here's what I have...

On Click:
SQLite.Query(db, "Insert into accounts(messages) values("..Enclose(message)..")", nil);

The problem is, this info does not reach the "messages" table, some where in the above code I must name a table. I couldn't find this info any where on this forum AND, it doesn't help that I'm a walking brain fart!

INSERT IGNORE INTO Table_Name (Field1, Field2...) VALUES(Val1, Val2...)

[sim]

LOL man I am LOST!
Here's what I have...

On Click:
SQLite.Query(db, "Insert into accounts(messages) values("..Enclose(message)..")", nil);

The problem is, this info does not reach the "messages" table, some where in the above code I must name a table. I couldn't find this info any where on this forum AND, it doesn't help that I'm a walking brain fart!

Your not the only one that gets confused on these topic lol.

[Bruce]

LOL man I am LOST!
Here's what I have...

On Click:
SQLite.Query(db, "Insert into accounts(messages) values("..Enclose(message)..")", nil);

The problem is, this info does not reach the "messages" table, some where in the above code I must name a table. I couldn't find this info any where on this forum AND, it doesn't help that I'm a walking brain fart!

[sim]

Bruce, it might be usefull to brush up on SQL a bit. The tutorial at W3Schools isn't too bad a place to start.
http://www.w3schools.com/sql/default.asp

Very useful :yes thanks from sim also :lol

[Bruce]

Bruce, it might be usefull to brush up on SQL a bit. The tutorial at W3Schools isn't too bad a place to start.
http://www.w3schools.com/sql/default.asp

Thanks Jim

[JimS]

Bruce, it might be usefull to brush up on SQL a bit. The tutorial at W3Schools isn't too bad a place to start.
http://www.w3schools.com/sql/default.asp

[sim]

I think I'm gonna go with one DB with two tables. I just need to learn how to access the second table.

If it was 2 DB's i say yes but if its 2 tables you should be able to call 2 tables like you would call 2 vebs
sorry I am little limited on this I remeber asking this my self some time back but I don't rember peoples
replys.

[Bruce]

I think I'm gonna go with one DB with two tables. I just need to learn how to access the second table.

[sim]

Can you have two databases open at the same time?

2.db files or to feeds in to the same DB?

[Bruce]

Can you have two databases open at the same time?