>Hi Cetin!
>
>If I use VFP tables, yes it does work. But when you access the same data via ODBC using parameterized remote view, the deleted records do not show up.. Does it has anything to do with remote views. I checked there is no option to include deleted records
>
>Raz
There are 2 options :
In connectionstring Deleted=Yes
or :
set deleted off
ie: lnHandle= SQLStringConnect('...Deleted=Yes')
or:
lnHandle=SQLStringConnect(...)
SQLExec(lnHandle,'set deleted off')
Cetin