Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating cursor with two children from one parent
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01346532
Message ID:
01346545
Views:
7
That's right, because the customer file is the head office table, and the sites are children of the customer file.

How do I get around this ?

>As I said in the previous message, you have duplicates in the customers or/and sites tables.
>
>>
>>I take your advice on board, thx
>>
>>but I only have 4 records in LINEMARKINGHEAD, but the cursor has 39 records in it?
>>
>>>It's better to use JOINs and formatimg to make your query readable
>>>
>>>SELECT linemarkinghead.icustno, customers.ccompany, sites.name ;
>>>	FROM linemarkinghead ;
>>>		JOIN customers ON linemarkinghead.icustno = customers.icustno ;
>>>		JOIN sites ON linemarkinghead.siteno = sites.code ;
>>>	INTO CURSOR tmp
>>>
>>>
>>>The only way you get more records by adding joins, if there're duplicate icustno in customers or/and code in sites.
>>>
Rob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform