Jump to content

Insert Variables into Table SQLite

Go to solution Solved by tanahara,

Recommended Posts

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


Link to comment
Share on other sites

  • Solution

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

  • Moderators


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. ;)


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:


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


Link to comment
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

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...