I need to know how I can load a database from VB. I'm reading info into variables, created the database with VB and SQL commands, but don't know how to wright that info into a particular field in the database.
Can anyone help?
Printable View
I need to know how I can load a database from VB. I'm reading info into variables, created the database with VB and SQL commands, but don't know how to wright that info into a particular field in the database.
Can anyone help?
UPDATE MyTable set MyField = 'MyNewValue' where KeyField = MyRecordID
Ok, looks good, but this is the first time I do this. Can 'MyNewValue' be a variable?
And do you know of a good Webpage that details these SQL commands with examples?
AmigaZoid
Yes you can use a variable, and yes, I do know of a good web page that is a great reference:
http://w3.one.net/~jhoffman/sqltut.htm
Great, Thanks.
One last question....
Can any SQL command be used in VB?