Announcement

Collapse
No announcement yet.

two open databases

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dermot
    replied
    Originally posted by Bruce View Post
    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

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

    Leave a comment:


  • Bruce
    replied
    Originally posted by Dermot View Post
    Code:
    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

    Leave a comment:


  • Dermot
    replied
    Originally posted by Bruce View Post
    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!
    Code:
    INSERT IGNORE INTO Table_Name (Field1, Field2...) VALUES(Val1, Val2...)

    Leave a comment:


  • sim
    replied
    Originally posted by Bruce View Post
    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.

    Leave a comment:


  • Bruce
    replied
    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!

    Leave a comment:


  • sim
    replied
    Originally posted by JimS View Post
    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

    Leave a comment:


  • Bruce
    replied
    Originally posted by JimS View Post
    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

    Leave a comment:


  • JimS
    replied
    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

    Leave a comment:


  • sim
    replied
    Originally posted by Bruce View Post
    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.
    Last edited by sim; 05-21-2010, 01:53 PM.

    Leave a comment:


  • Bruce
    replied
    I think I'm gonna go with one DB with two tables. I just need to learn how to access the second table.
    Last edited by Bruce; 05-21-2010, 01:45 PM.

    Leave a comment:


  • sim
    replied
    Originally posted by Bruce View Post
    Can you have two databases open at the same time?
    2.db files or to feeds in to the same DB?

    Leave a comment:


  • Bruce
    started a topic two open databases

    two open databases

    Can you have two databases open at the same time?
Working...
X