Jump to content
Sign in to follow this  
antmar904

Insert Variables into Table SQLite

Recommended Posts

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())

post-75109-0-04192900-1394812893_thumb.j

Share this post


Link to post
Share on other sites
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 by tanahara
Added code tags

Share this post


Link to post
Share on other sites
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


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
antmar904

Got it thank you very much :) 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×