Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Local Views at Wits End
Message
De
06/06/2003 17:22:36
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00796970
Message ID:
00797503
Vues:
28
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform