Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local Views at Wits End
Message
From
06/06/2003 17:22:36
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00796970
Message ID:
00797503
Views:
29
I'm sorry if I've confused matters. I've developed a framework that uses views exclusively to access local tables (all free tables) or data stored in SQL server. It's become my new religion to never-ever open a table directly. Every one of my forms is free of any tables or views when it loads - all views are added from meta-data when the form loads - I even create my view DBC on the fly.

I checked my underlying SYSINFO.DBF table in the debugger and it reports a buffermode of 0 (none). Hmmm... Everything works FINE if:

a) I close the underlying table (that the view opened originally) right before I call the TableUpdate()

b) Change the type of table to FOX2X (you can't *make* me go back there..)

I have a view object that I use for all data access (think of a half-baked cursor adapter). After every requery() and before every PUT() I simply issue a USE IN SELECT("SourceTable"). That forces the view to re-open it's source fIt works, but I don't like it. I'll try to post some repro code over the weekend - this really shouldn't be happening.

Thanks for your time and tenacity!

Best Regards,
~Erik Folley
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform