-
When I run this sql:
mysql = "select * from cri where stock like '[89*]';"
Data1.RecordSource = mysql
Data1.Refresh
I am getting this error:
Too vew parameters, expected 1 (3061)
What could be wrong in my select statement, and how to learn the equation of putting the correct position of commas, punctuation, semicolon etc so I will not face this kind of problem
Please help
Appreciated in advance
-
try
mysql = "select * from cri where stock like '89*'"
-
-
What a mestake I was doing, The feild name was not completed, it was stock number not only stock,,,,I reaply the sql with the correct name and it work correct
Thanks for your particiption