Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Statements
Message
 
 
To
20/12/2004 17:08:22
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00970832
Message ID:
00970883
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform