Syntax error the second time I run the query 
Author Message
 Syntax error the second time I run the query

Hi.

Is there any known reason to get a syntax error (ErrorCode 3075) when I
open() an specific RecordSet after I close() it ?

I get the next error:

Syntax error in number in query expression "ID = 1 AND Name = 'LUIS''

Thanks in advance.

Fernando Ramos



Sun, 17 Sep 2000 03:00:00 GMT  
 Syntax error the second time I run the query



Quote:
> Hi.

> Is there any known reason to get a syntax error (ErrorCode 3075) when I
> open() an specific RecordSet after I close() it ?

> I get the next error:

> Syntax error in number in query expression "ID = 1 AND Name = 'LUIS''

> Thanks in advance.

This error is the result of a internal timing problem of the Access driver
that has been around since they are useing multiple threads in the jet
engine (Version 2.5 methinks). I have code that catches this exception and
retries the statement until it succeeds. Are you useing the latest Access
driver? I wonder if they ever going to fix this.


Mon, 18 Sep 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with METADATA the second time run

2. Syntax error in query expression

3. CDaoRecordset: Syntax error in number in query expression

4. Run time Release mode error but no Debug mode error

5. Abnormal Program Termination Error -- MS C++ Run Time Library Error

6. Abnormal Program Termination Error -- MS C++ Run Time Library Error

7. Abnormal Program Termination Error -- MS C++ Run Time Library Error

8. Looking for a time function/code to add 1 second to time structure

9. Function question Part 2 ( RUN TIME ERROR PROBLEM )

10. Run-time Error??!!

11. Specialised tool for run-time error detection

12. Run time error?!?!

 

 
Powered by phpBB® Forum Software