I'm working on my first database intensive program, and I don't have any good references on SQL.
I couldn't even get a simple SELECT statement to work. What I need is a sample statement. Here's what I tried:
"SELECT * from myTableName WHERE " & myTableField & "=" & myData
myData is a string. The database is Access, and I get a syntax error on SQL statement.
Can someone please help?
Any good references on the Net?
Thanks,
Todd
I couldn't even get a simple SELECT statement to work. What I need is a sample statement. Here's what I tried:
"SELECT * from myTableName WHERE " & myTableField & "=" & myData
myData is a string. The database is Access, and I get a syntax error on SQL statement.
Can someone please help?
Any good references on the Net?
Thanks,
Todd