Find & Replace via ODBC/JDBC

[Stuart Sevastos]

I need some help, I am using FileMaker Pro as a front end to an SQL backend, I have the insert and update scripts going, but I am having trouble in getting a Find & Replace script going.

Any idea's are welcomed.

[Dan-A]

Could you use a Select query with a WHERE clause...

Something like...

SELECT sqlTableName * (or each field you want to select)

WHERE sqlKeyField = FM_keyfield

check for a match or an error then if you have a match perform your update

query making sure you have a WHERE clause in your update query to

update only the matching record and not all the records.

HTH

Dan