HE: Syntax Error in UPDATE statement 
Author Message
 HE: Syntax Error in UPDATE statement
I'm trying to "copy" data form one database to another using the
SQL-Statements.

I always get an error message "Syntax error in UPDATE- statement" and can't
see the error.

My SQL string is like

Update A, A in '\\data\test.mdb' As Source Set A.f1=Source.f1 where
A.Id=Source.Id



Sat, 14 Sep 2002 03:00:00 GMT
 HE: Syntax Error in UPDATE statement

'\\data\ ????
is data a pc or a directory?



Quote:
> I'm trying to "copy" data form one database to another using the
> SQL-Statements.

> I always get an error message "Syntax error in UPDATE- statement" and
can't
> see the error.

> My SQL string is like

> Update A, A in '\\data\test.mdb' As Source Set A.f1=Source.f1 where
> A.Id=Source.Id



Sat, 14 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. (0x80040E14) Syntax error in UPDATE statement.

2. Syntax Error in Update Statement

3. Syntax error in UPDATE statement

4. Syntax error in UPDATE statement

5. Syntax error in UPDATE statement while using a Memo field

6. (0x80040E14) Syntax error in UPDATE statement.

7. Why "Syntax error in UPDATE statement" error?

8. -2147217900 Error: Syntax error in INSERT INTO statement

9. UPDATE statement syntax

10. Need help with Syntax on Update or Insert SQL Statement

11. Update Statement Syntax

12. NEWBIE: easy syntax question with UPDATE statement


 
Powered by phpBB® Forum Software