>I have 2 tables, one parent and one child, a one to many relationship
>
>parent is having - code and description fields
>child is having - code, date & quantity fields
>
>i'm issuing this command
>
>sele parent.code, parent.description, child.date, child.quantity from parent, child where parent.code=child.code to file myfile
>
>& it gives me a output in a text file, where each and every parent field is repeated, in front of its child record...
>
>is there a way i can get parent field once and below that child records...(i don't want the repetition of parent fields and output should be transfered to txt file.)
>
>
>any help will be highly appreciated, (i don't want to use the report designer only with help of sql or any other command).
>
>thanks in advance...
You can generate text file using low-level functions
nHnd=fcreate("output.txt")
select parent
scan
=fputs(nHnd,parent.code+parent.description) && you should handle data types
select child
scan for child.code=parent.code
=fputs(nHnd,child.date+child.quantity) && you could separate fields
endscan
endscan
Edward Pikman
Independent Consultant