Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View parameter used in outer join
Message
 
To
21/03/2007 18:58:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01206850
Message ID:
01207097
Views:
19
>I have this working but I am curious as to why.
>
>I recently had to modify a view. Moved the view parameter from the WHERE clause to the OUTER JOIN.
>
>The view is opened NODATA in the form's dataenvironment. Of course it blew up the first time I ran the form (issued prompt for a value for the view parm). I figured out that since the parameter is now in the join, the paramater is being evaluated when FoxPro is creating the structure for the view even thought the view is opened NODATA.
>
>So I got it to work by declaring the view parm LOCAL in the form's OpenTables method, but here is my question:
>
>Why do I also need
>
>NODEFAULT
>DODEFAULT()
>
>I thought that baseclass code ran automatically?
>
>TIA

NODEFAULT and DODEFAULT() are complete opposites. The first prevents running the parent event or method of the object. The second runs the parent event or method of the object.

I don't think the parent code is ran automatically if you place any code in the event or method of the object. It overrides the parent code. That's why I usually add a DODEFAULT() somewhere in the event or method if I want the object to also run the event or method of the parent of the object.

HTH,
Ariel
Speak using soft and sweet words in case you have to eat them later.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform