recall command on a VFP table through Vbasic and OLEDB

[foxitaly]

Hi

Are There some version limitation to recall deleted record in a VFP table trough VbasicApplication>VFPOleDBprovider ?

Or is command out of question through ODBC or OLEDB ?

 

[ramani]

Hi

I am not aware of any such limitation.

1. RECALL will work, till the table is packed.

2. If you have SET DELETED ON
Then the deleted records are not available. So any attempt to RECALL NEXT ONE or such command could fool you, since you could be having the pointer on a non deleted record.
SET DELETED OFF and then try to see if this helps.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[foxitaly]

Sorry No, I need to use VBasic to connecto to a VFP table and RECALL the data set as deleted

So Vbasic > OLEDB > RECALL COMMAND