Re: How to sort Detail records on Forms? (and other Q's)

In article <3qvbak$i8e@access5.digex.net>, Brian G. <briang@access5.digex.net> wrote: } } 2) Does informix have a PRIMARY KEY designation that I haven't been } able to find in the manuals? } Starting with 5.00 of the engines, PRIMARY KEY is supported. } 3) In a Master/Detail relationship on a screen form, how do you specify } the order of the rows to be returned in the detail records? } I always use two cursors in a Master/Detail relationship. This gives me the advantage of doing two entirely different things with my data if necessary (including sorting). BTW, I assume your talking about 4GL? If not... GET 4GL!!! Then ftp my code generator from the Informix archives, you'll never want to use Perform again :-) } 4) I have stumbled upon the COMPOSITES statement in the INSTRUCTIONS } statement in one of the forms inherited, and have been able to find } no mention of it in any of the books. Talking with someone else } about it, they mentioned that it is one of their 'undocumented } features' to perform joins on multiple-field keys. This seems like } something that would be fairly useful not to go undocumented. } Are there any more undoc'd features like this I should know about? } Now I'm looking at an old manual (4.00) but on page 3-71 COMPOSITES is documented. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA EMAIL: (w) ddx85qr@bell-atl.com (h) dave@das13.snide.com WEB: http://www.ece.vill.edu/~dave/ (Now NETSCAPE enhanced!)