SET DELETED setting in VFP program doesn't affect ODBC connection. You can either specify Deleted=No in the connection's connection string before open it or try to send SET DELETED OFF to the VFP ODBC in Sqlexec().

>Hi All,
>
>I am trying to retrieve all records for a project including the Deleted ones.

>SET DELETED OFF   && Set to ON == same result :-(
>
>cSqlStatement = "SELECT SALES_ORD.po_seq_no " + ;
>                "FROM main_one!SALES_ORD " + ;
>                "WHERE SALES_ORD.proj_no = ?lnProjNo " + ;
>                "ORDER BY SALES_ORD.po_seq_no "
>
>nConHndl = sqlexec(nSatHandle, cSqlStatement, 'temp_cursor')

>This only gives me the records that are not deleted. I want them all. How?
>
>
>I am using VFP6 SP5. The database is a VPF 'DBC' database located on the network. The query goes through the VFP ODBC.
>
>TIA
>Mike