Subject | What is wrong? |
---|---|
Author | André Poisson |
Post date | 2001-04-21T03:01:05Z |
Using IB_WISQL.
UPDATE FACTURE INNER JOIN CLIENTS ON FACTURE.NoTelephone =
CLIENT.NoTelephone SET FACTURE.NoClient = Client.NoClient;
And I get this:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 15
INNER
By the way this works in Access.
Any help would be appreciated.
André
UPDATE FACTURE INNER JOIN CLIENTS ON FACTURE.NoTelephone =
CLIENT.NoTelephone SET FACTURE.NoClient = Client.NoClient;
And I get this:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 15
INNER
By the way this works in Access.
Any help would be appreciated.
André