You will have to put a stored Proc in the DBC and pass the "WHERE" clause to that as a parameter via a SELECT SQL. Then your SP can do a RECALL FOR parameter.

SELECT SP_NAME("where_clause") FROM DUMMY_TABLE

Your dummy table need only have 1 or no records and only 1 field.

>Hi All,
>
>I am wondering how to RECALL a deleted record through ODBC connection using SQLEXEC. I want to avoid retrieving, setting cursor properties, recalling the record and then issueing a TABLEUPDATE(). I can do DETETE FROM tblname WHERE something. Why not RECALL FROM tblname WHERE something?
>
>I am using VFP6 SP5. The database is a standard Foxpro '.DBC'
>
>TIA
>Mike