>CREATE SQL VIEW lvShipping AS;
> SELECT SO.PONO,;
> INVOICE.CUSTCODE,;
> CUSTOMER.NAME AS CUSTOMERNAME,;
> INVOICE.SHIPDATE,;
> INVOICE.TRANSPORTCODE,;
> TRANSPORT.NAME AS TRANSPORTNAME,;
> INVOICE.WAYBILLNO,;
> INVOICE.ID,;
> INVOICE.INVDATE,;
> INVOICE.SOID;
> FROM AMS!INVOICE;
> LEFT OUTER JOIN AMS!SO ON INVOICE.SOID=SO.ID;
> LEFT OUTER JOIN CUSTOMER ON SO.CUSTOMERID=CUSTOMER.ID;
> LEFT OUTER JOIN CUSTOMER_SHIP_VIA ON INVOICE.TRANSPORTID=CUSTOMER_SHIP_VIA.ID;
> LEFT OUTER JOIN TRANSPORT ON TRANSPORT.ID=CUSTOMER_SHIP_VIA.TRANSPORTID;
> ORDER BY INVOICE.SHIPDATE DESC

> USE AMS!lvShipping IN 0 SHARED
> CURSORSETPROP("SendUpdates", .T., "lvShipping")

Why not used the DBSETPROP() function to set the keyfield list, updatable list... To get all the properties of the VIEWS. Read the DBGETPROP() from your MSDN. This sure helps you to complete your coding.