>>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 ??
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only