Hi, as my experience shows, if you just "SELECT file BY-DSND TOTAL.PRICE SAMPLE 100", it will take any 100 records and then sorts them. If you "SELECT .. BY DSND" first, that might really do the trick.
VK On Nov 10, 1:18 am, Charlie Noah <[email protected]> wrote: > WW, > Try > SELECT file BY-DSND TOTAL.PRICE SAMPLE 100 > You might have to split it into 2 commands if Jbase does the sample first: > SELECT file BY-DSND TOTAL.PRICE SELECT file SAMPLE 100 > Regards, > Charlie Noah > > Tiny Bear's Wild Bird Store > "Everything For The Backyard Bird Enthusiast, Except For The Birds" > Info, Forum: http://www.TinyBearMarketing.com > Store: http://Stores.TinyBearMarketing.com > On 11-09-2011 4:52 PM, wsw wrote:Is there a english command to select the top > 100 records because I can't find it I have an attribute TOTAL.PRICE and I > want to select the top 100 records highest to lowest. Thanks in advance, WW -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
