Subject Re: [IBO] Index order
Author Robert martin
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
Wild Software Ltd
----- Original Message -----
From: Woody (TMW)
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

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.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Sponsor

Get unlimited calls to


Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

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

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