Addnew records to SQL ver6.5

[nigel_chong98]

How to construct the command line if i would like my VB program to addnew record to SQL? Can refer to my prior question on 'Where is the problem' for a clearer idea.

Thanks for the effort taken to help me.

[Ianpbaker]

It goes something like this


strSql = "INSERT INTO tbltest(string1,date1,number1)" & _
" VALUES('" & strString1 & "','" & txtDate1.value & "'," & iNumber1 & ")"

db.execute strSql


This Example lets you Insert 3 specific fields, But you can leave out the (string1,date1,number1). If you leave this out you have to enter all fields and set The ones you don't want to NULL.


strSql = "INSERT INTO tbltest" & _
" VALUES('" & strString1 & "','" & txtDate1.value & "'," & iNumber1 & ",NULL,NULL)"

db.execute strSql


Hope This Helps

Ian