I think you have few errors in your coding. Just break down the sting, build it stepwise. I have done it for you, just have glance over it.
dim test as string
Code:
test="INSERT INTO users (FirstName,LastName,Password,Status) Values ("
test=test+FnameBox.text+", "
//msgbox test
test=test+LnameBox.text+", "
test=test+PwordBox.text+", "
test=test+StatusBox.text+")"
If db.Connect then
//connected to database...OK
msgbox test
//quit
db.SQLExecute ("test")
My Msgbox displays"
INSERT INTO users (FirstName,LastName,Password,Status) Values (Sam, Adams, 1234, A)
Bookmarks