>Hi,
>
>How can I recall a record thats marked for deletion when Im connection to a foxpro table with ado.
>
>I tried..
>oConnection.execute("RECALL FOR recid=48 IN MODACAD")
>
>Of course this doesn't work..
>
>Can I do it somehow with a recordset?
>
>Im using free tables.
>
>Thanks
>Tim
Tim,
Actually you can do it :) Sounds funny but VFPOLEDB provider lets you call not only stored procs but compiled fxp as well :) OTOH it's debatable if then it could be considered you're doing it via OLEDB or VFP in fact. You might not call all commands that you would be able to do from a prg but at least works for your case. ie :
*Source for recallme.prg
Lparameters tcTableName, tcExpr
Select 0
USE (m.tcTableName) Again Alias rcall
Recall for Evaluate(tcExpr)
Use
*Code say from an asp using it :
set oResult = .Execute( "RecallMe('employee','between(recno(),3,10)')" )
PS: fxp is in the same path with data and you've read&exec rights for IUSR_machinename.
Ability to do it is never a suggestion to do it :)
Cetin