I'm in a rich client environment using VFP front end and SQL server as back end. All data coming from SQL server is stored in updatable cursor using SQL pass-through.
The cursor is composed of the SQL statement below
SELECT IN_ItemSupplier.ID, IN_ItemSupplier.cCode,IN_ItemSupplier.cDesc, AP_Supplier.cDesc AS cDescSupplier FROM IN_ItemSupplier
LEFT JOIN AP_Supplier ON IN_ItemSupplier.Fk_Supplier = AP_Supplier.ID
I would like to update field in the IN_ItemSupplier table only. How should I proceed?
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)