Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with use .. nodata
Message
From
11/01/2007 06:53:52
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
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:
01184487
Views:
13
Fabio,

never mind. I know exatly how to get arround. (And it was bad code anyway.) I was just curious.

I leave the whole view idea anyway, I swap step by step to CA's. I have my CA class and this open and requery "sub" CAs as needed.

Doing that I come to the conclusion that something like REQUERY('subview',lAllParentViews) is to simple, I have sometimes multiple use of some sub views and it's not easy to determine to order of requery and to call each CA only once. Also some CAs are static and need no requery (infact, my 'viewB' is, so it was never called in an requery.)

Agnes
>>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.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform