Very Computer

Environment Windows 95/NT VC++5

I'm faced with a strange problem when using the CDaoRecordset Open() or
FindFirst() function with a SQL-query:
Although the SQL-query is simple and absolutly correct, a CDaoException
('Syntax error in number in query expression!')is thrown when calling the
function for the first time.
After that, if I repeat the execution with exactly the same query,
everthing works fine and I get my desired recordset.

Is there anyone who has a clue ?
Cheers, Wolfgang

Quote:

> I'm faced with a strange problem when using the CDaoRecordset Open() or
> FindFirst() function with a SQL-query:
> Although the SQL-query is simple and absolutly correct, a CDaoException
> ('Syntax error in number in query expression!')is thrown when calling the
> function for the first time.
> After that, if I repeat the execution with exactly the same query,
> everthing works fine and I get my desired recordset.

Quote:>Yes, the jet engine does this sometimes when useing a numerical expression
>in a query. It's a well known and never fixed bug. Are you useing the
>latest driver version? I have given up testing this bug against every new
>version of the jet engine. The remedy is to retry until success.

SELECT * FROM Users WHERE (group = 1) AND (x  =  x)

for numbers.

Brian

Quote:

> > I'm faced with a strange problem when using the CDaoRecordset Open() or
> > FindFirst() function with a SQL-query:
> > Although the SQL-query is simple and absolutly correct, a CDaoException
> > ('Syntax error in number in query expression!')is thrown when calling the
> > function for the first time.
> > After that, if I repeat the execution with exactly the same query,
> > everthing works fine and I get my desired recordset.

> Yes, the jet engine does this sometimes when useing a numerical expression
> in a query. It's a well known and never fixed bug.

To solve this problem, derive a class from CDaoRecordset, overwrite Open and
FindFirst and derive all your recordsets from this class.

The new functions catch the CDaoException and call the original function a second
time.

--
---------------------------------------------------------------
--  Robert Lechner, University of Technology, Graz, Austria  --

---------------------------------------------------------------