Insert Variables into Table SQLite

[antmar904]

I no nothing about sql at all.

any help will be much appriciated.

when i try to insert values into a a table i get the info in 3 diffrent rows.

how do i make it insert into the same row?

sorry if its hard to understand.

If Not _SQLite_Exec(-1, "INSERT INTO persons (Name) VALUES (" & _SQLite_FastEscape($Name) & ")") = $SQLITE_OK Then _
        MsgBox(16, "SQLite Error", _SQLite_ErrMsg())
If Not _SQLite_Exec(-1, "INSERT INTO persons (Location) VALUES (" & _SQLite_FastEscape($Location) & ")") = $SQLITE_OK Then _
        MsgBox(16, "SQLite Error", _SQLite_ErrMsg())
If Not _SQLite_Exec(-1, "INSERT INTO persons (ComputerName) VALUES (" & _SQLite_FastEscape($CompName) & ")") = $SQLITE_OK Then _
        MsgBox(16, "SQLite Error", _SQLite_ErrMsg())

[tanahara]

This is because you are executing 3 seperate inserts do this

 
If Not _SQLite_Exec(-1, "INSERT INTO persons (Name,Location,Computername) VALUES (" & _SQLite_FastEscape($Name) & "," & _SQLite_FastEscape($Location)& "," & _SQLite_FastEscape($CompName)& ")") = $SQLITE_OK Then _
MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) 

Think of a SQL insert as a row of data, that one row of data includes all those columns.
 
So since you had 3 you made multiple rows leaving out information on each.

$InsertSQL = "INSERT INTO persons (Name,Location,Computername) VALUES (" & _SQLite_FastEscape($Name) &","&_SQLite_FastEscape($Location) &","& _SQLite_FastEscape($CompName) &")"

If Not _SQLite_Exec(-1, $InsertSQL) = $SQLITE_OK Then _
    MsgBox(16, "SQLite Error", _SQLite_ErrMsg())

This is how I recommend doing your insert, created a string allows you to msgbox that string so you can see exactly what your insert string looks like. It also makes your sqlite execution code easier to read. This is just personal pref.

Edited March 14, 2014 by tanahara
Added code tags

[Melba23]

tanahara,

When you post code please use Code tags - see here how to do it. Then you get a scrolling box and syntax colouring as you can see above now I have added the tags.

M23

[tanahara]

tanahara,

When you post code please use Code tags - see here how to do it. Then you get a scrolling box and syntax colouring as you can see above now I have added the tags.

M23

Ops I thought I put it in the code tags, my bad. I appreciate it.

[antmar904]

Got it thank you very much