Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with use .. nodata
Message
 
 
To
11/01/2007 06:15:01
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:
01184560
Views:
13
>>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.

I believe you mean Re: View with NODATA on Load produces no records after REQUE Thread #1117647
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform