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