Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table appears twice but only one populated
Message
From
26/09/2007 08:43:13
 
 
To
26/09/2007 08:24:48
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01256696
Message ID:
01256888
Views:
14
>>>Hi Guys
>>>
>>>I have this form for maintaining bus operator details.
>>>Now one operator (company) may be owned by another operator (company).
>>>So the Operator table appears twice in the DE - one with alias "OPERATOR1" as opposed to the default.
>>>
>>>The subject Operator table has a foreign key to its owner (ie another operator rec - which, btw, I don't have as a cyclic reln. in the DD). Just for the purposes of this form I have that pointing at the operator ID of OPERATOR1 in the DE. SO on the form I have a listbox to the OPERATOR1 "version" of the table, so that the subject operator's rec can have its owner selected froom the listbox.
>>>
>>>Now then, only trouble is the listbox is empty at runtime. Now I developed this a few years ago and I can't see that I let this flaw go in testing.
>>>
>>>Any ideas? BTW it definitely is the same table USEDd AGAIN.
>>>
>>>'ppreciate it
>>>
>>>Terry
>>
>>UPDATE on this:
>>
>>In debug watch window I have dbf() function and this confirms that when I select either OPERATOR (initselalias)or OPERATOR1 (the reUSEd operator table, used to supply the listbox) they are indeed the same table (same path) BUT a browse of OPERATOR1 is empty, as if it's a different empty table.
>>
>>Really flummoxed over this one!
>PMFJI, Filter?

Filter - what?

There are no filters - just the whole table supposed to be oin the listbox, as any operator can become the owner of another.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform