Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Local Views at Wits End
Message
 
À
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:
00797871
Vues:
35
That part about it having to be a Fox2X table is definately strange! If you start with a new SYSINFO table that you build from scratch, does it still behave this way?

>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,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform