Help,
what is the problem here??Code:Rstring = "select * from `custmers`"
DBr.Open Rstring
i see no problem and the softwere says its illegle.
-k3pos
Printable View
Help,
what is the problem here??Code:Rstring = "select * from `custmers`"
DBr.Open Rstring
i see no problem and the softwere says its illegle.
-k3pos
Your SQL string should be...
assuming also that that is the way you spell customers.Quote:
Rstring = "select * from custmers"
You use ' marks in most SQL queries to show text values, for example
Code:Rstring = "SELECT * FROM custmers WHERE custmer_name = 'Jones' "
If you are using ADO, you need to add the connection objectCode:Rstring = "select * from `custmers`"
DBr.Open Rstring, ConnObjectGoesHere