Hi Woody

Sorry about the delay, been in a meeting. I get your posts fine here :)

The current system (bear in mind its a conversion from BDE / xBase) uses the following index

LineOrder -> Rank, SubRank

Each item gets a rank from 1 upwards. Discount and Freight get a much larger number. So the items always show in entered order and if discount etc is entered it appears at the bottom.


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Woody (TMW)
To: IBObjects@yahoogroups.com
Sent: Thursday, December 09, 2004 12:29 PM
Subject: Re: [IBO] Index order


On a personal note, my posts don't seem to be coming through to my email
anymore.

Now, on to your problem again:

>
> Yup :)
>
>> So, where exactly do you want a new record to be inserted? At the end
of the
>> normal items and before the special items?


How do you get them to order by that position now? That may help solve your
current situation.

Woody (TMW)



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]