Hi,

See message# 517841 for an example of how to create an updatable SPT cursor. While the sample is for SQL Server, the same principle applies to MySQL. An easy way to get the right syntax is to create an updatable remote view and then query these properties with CURSORGETPROP().

HTH
>How Can I make the cursor updatable by using SQL Pass through?
>
>eg.
>
>SQLEexc(lConn,"SELECT * FROM supplier","cSupplier")
>
>How can I make the cSupplier updatable (something like REMOTE VIEW)?
>
>TIA.