Hi!

Mark, it is a new for me too that VFP SP could be used directly through ODBC this way. I guess this is a good item for FAQ article, because this question is asked a lot of times at forums and newsgroups.

>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