Help with SQL syntax...

[Dan-A]

Hi all,

I can't figure the structure/syntax my SQL statement should have...

When i use the ODBC import... my fields are enclosed in `field` sometimes

they are like this: `tblName.fieldName` ...

If i want to update an access 2000 tbl with data from fileMaker

how would I write that??? UPDATE tbl SET fields etc..

with commas or semicolons? with ` or ' or " ??

thanks

[SJM]

I'm not sure that this is directly applicable but maybe it will be useful as a start. I have had success passing a string of the following form to FileMaker (not Access) via ODBC to cause an update of the Clients table.

"UPDATE Clients SET `flag_qb_modified` = 0 WHERE `client_id_number` = 523"

Note the outer double-quotation marks are not part of the string, they are just part of how the string is represented in the source code file. But the inner back-ticks around field names are in the string.

[Dan-A]

thanks for the tip...

I will try that

[Dan-A]

YEAH!!! found a syntax that works!!

"UPDATE tblTempInbox SET DispoStatus = '" &Trim (IncomingNouveauMail::t_StatutDispo) & "' WHERE MemberID = '" & Trim(IncomingNouveauMail::t_MembreID) &"'"

I had to use the trim function...for some reason i kept getting a leading space in all my fields so nothing would match & update!