Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with use .. nodata
Message
From
11/01/2007 06:15:01
 
 
To
11/01/2007 02:14:24
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01184449
Message ID:
01184478
Views:
15
>Hi all,
>
>I found a problem (or behaviour change) from VFP 8 to 9. I don't realy need help on this. It's just for information and because I didn't find it mentioned elswhere.
>
>I have a view "viewA" that is based on an other view "viewB".
>If I do
>
>close tables all
>USE viewA NODATA
>
>
>the result will be in VFP 8.0 (and in 7,6,5)
>viewB is opend with data, viewA without
>the result will be in VFP 9.0
>viewB is opend without data, viewA without
>
>SET("EngineBehavior") returns 70
>
>Is this known? Is there a workaround that gives the way VFP8 works back?
>
>Agnes

Hi Agnes,

I see this into on a thread,
where VFPT's Aleksey comment this change.

Try to use REQUERY('ViewB') .....

Because, requery() reload ViewB, but not ViewA,
a full REQUERY('subview'), it is unusable on every VFP version.

lack a new parameter,
USE subview REQUERYALL
REQUERY('subview',lAllParentViews)
For me VFP allow subview, but the support is not good.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform