>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