Too few parameters
Manny
07001:[Microsoft][ODBC dBase Driver] Too few parameters. Expected 4.
What does it mean? I know the Param property of TDatabase is empty the
reason being i don't need to put a user name or password to access the
databases.
How can i bypass the username and password thingy or bypass it from having
to check for the Param property.
Manny
man...@hotmail.com
Rohan Lam
if you think a parameter is not required, you still need to pass a NULL or
"" or 0 depending on the parameter type. You cannot ignore it.
Manindra
Select * From ben.dbf where ((status = "ACTIVE") or (status = "SBW") or
(status = "INESC"))
and this is the error i get
07001:[Microsoft][ODBC dBase Driver] Too few parameters. Expected 3.
Does it atleast mean that i'm able to connect to the dataarea so the
problem only exists with open of database using SQL?
Manny
Rohan Lam <roh...@microsoft.nospam.com> wrote in article
<ekB13pqA#GA....@uppssnewspub04.moswest.msn.net>...
John E. Hobson
SQL standard specifies single-quotes for string literals. Most likely the
double-quotes make the driver think you are specifying column names. When the
driver cannot find a column by this name, it thinks it's a parameter. A lot of
people seem to run into this problem.
Select * From ben.dbf where ((status = 'ACTIVE') or (status = 'SBW') or (status
= 'INESC'))
Manindra
able to close the cursor before closing the TQuery component. I get this
error saying cannot close Binding something like that.
And it changes the cursor type to static then i have to change it back to
Dynamic.
Reply soon.
John E. Hobson <Jo...@haht.com> wrote in article
<36388017...@haht.com>...
Manindra
able to close the cursor before closing the TQuery component. I get this
error saying
while a cursor is open"
And it changes the cursor type to Static then i have to change it back to
Dynamic.
Manny