Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PARENT is not an object?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00065410
Message ID:
00065692
Views:
52
Colin,

>SELECT Buil, Buildesc FROM BUIL ;
>WHERE PB AND Proj=This.Parent.Parent.Column9.cboProj.Value ;
>INTO CURSOR cBuillist ORDER BY Buildesc

You generally can not use object properties in SELECT statements, because VPF is prone to query them when the object you expect is not the current object. Pull the property to a local memvar at the time you execute the select:

lcProj = this.parent.parent.column9.cboProj.Value
select ...
where pb and proj=lcProj...
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform