>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

FOUND IT!

lnHandle = SQLExec(nConnexion, 'SET DELETED OFF')