Hi Bob,

A database was created with a view to the remote sql database.
The View Inventory_local2 does not have joins.
New is the VFP free table.

Update INVENTORY_LOCAL2 ;
SET OCR = 'X' ;
WHERE Catalog = NEW.Catalog AND ltd_editio=NEW.LTD_EDITIO

This will produce an update conflict only if the sql table column named OCR has "Long Text" showing.

Thanks.