Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view against VFP tables - deleted recs?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01523480
Message ID:
01523562
Views:
80
This message has been marked as the solution to the initial question of the thread.
A query does not transfer deleted mark into result cursor. You may try to add , DELETED() AS DelMark to the view.

>Oook - I decided to reboot - seeing how this machine hadn't been rebooted in like 3 1/2 weeks (a record for XP I think) - and now I see the deleted records - whoohoo! But - in the remote view the delete mark doesn't indicate which records are deleted. I was hoping there would be a way I could tell IN the remote view which records were flagged for delete - but I guess it's not possible? Rats!
>
>>Yes you can but it's ODBC connection level setting. See http://www.berezniker.com/content/pages/visual-foxpro/visual-foxpro-odbc-driver
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform