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
Mark McCasland
Midlothian, TX USA