Robert1
|
| Posted: 04/18/2005, 7:05 PM |
|
The following error message occurred when searching values in the yellow page directory, in a Access Database.
Form: Grid Directories
Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (Microsoft OLE DB Provider for ODBC Drivers).
Can any one described how to trouble shoot this? Thanks.
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/19/2005, 2:53 AM |
|
Hello,
Usually the error occurs when non existing field is used in a query, field name is misspelled. You can print the generated query from Before Execute Select (sample code is provided in CCS help http://docs.codecharge.com/studio/html/ProgrammingTechn...Output.html?toc) and test it against database. Usually more informative message is returned, that helps you to find the reason of error.
_________________
Regards,
Nicole |
 |
|
Too Few Parameters
|
| Posted: 04/19/2005, 7:30 PM |
|
Thanks Nicole.
I was referencing the wrong grid form.
Thanks
Robert
|
|
|
|
Jaeg
|
| Posted: 05/02/2005, 4:28 AM |
|
Hello.
Im sorry to use your Post , but i have the same problem here :
Select top 10 Sum(Bytes) as BytesTotal, SourceIP, ClassName
FROM tbl_AllData
WHERE ClassName like "/Inbound/Proxy*"
Group By SourceIP, ClassName
Order by 1 DESC;
If i put in Access , it returns well , but if i use in the code it gives me the same problem.
What can it be ?
Thankx
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/02/2005, 9:42 AM |
|
Jaeg,
This is a different problem, just the error message is the same.
You cannot use quotes in SQL and you will need to use single quote instead (').
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
