>>I have 2 tables :-
>>
>>1. Name :- which is having 4 fields :-
>>
>>code, name, age, male
>>
>>2. Contact :- Which is having 2 Fields
>>Code, Phone
>>
>>I am using following code :-
>>
>>AllFields="name.name,name.age,name.male,contact.phone"
>>Set fields to &AllFields
>>copy to array MyArray
>>
>>There are 3 records in Name & 4 records in phone:-
>>
>>It is giving me in array the associated record in contact for first 2 records, but for the 3rd record it is showing me all .f. values
>>
>>Can Anybody Tell me, what's wrong ???
>
>Are there 3 records in table 2? I would do this with an outer join to a cursor and then copy to array from the cursor, or just use the cursor directly (even better).
>
>HTH
There are 4 records in table 2. See, I want to use Set fields only. Is there a way to do it ??
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement