Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Statements
Message
 
 
À
20/12/2004 17:08:22
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00970832
Message ID:
00970883
Vues:
18
First, what is the error #/message? You can use AERROR() to get more information. Second, I would just create the remote view ONCE, and parameterize it.

...WHERE PAIS_pomas.jobnum = ?nJobNum

You can then open the view with no data in the DE of a form or anywhere else. Then set the variable (parameter) nJobNum to the needed value. Then issue REQUERY('ViewName') command to get the data. When the job # changes, TABLEUPDATE() on the view to save any changes (or TABLEREVERT()), before setting the new value of nJobNum then REQUERY again.

Every time you successfully create the view, the view definition that currently resides in the DBC gets deleted [the DBC is a glorified table, so the view definitions records get deleted but not packed], then a whole new set of records are added to the DBC. Your DBC will bloat very quickly by doing this.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform