HyperCard Mailing List

Hi.. I am doing my end of year accounts. I have a Hypercard Invoice stack with various sort buttons.. eg "sort by client name" (brings same clients invoices together), or "sort by company" etc
I want to bring stack back to original order so wrote a "sort by invoice number"
Each invoice is on a separate card.
Each card has a bg field called "invoice number"
this field has a number .. first card was 1, second 2, one hundreth 100, and so on up to the thousands eg 2347
I wrote a simple script "sort stack by bg field "invoice number"
I am getting a result where, for example, invoices 1,10,100 follow each other when the script has run.
or 979,99,980 follow each other
Whereas I want the stack ordered by usual numeric sequence eg 1,2,3 ..... 979,980,981.....
I am sure there is a simple answer and would be grateful for help.

Hi.. I am doing my end of year accounts. I have a Hypercard Invoice stack with various sort buttons.. eg "sort by client name" (brings same clients invoices together), or "sort by company" etc
I want to bring stack back to original order so wrote a "sort by invoice number"
Each invoice is on a separate card.
Each card has a bg field called "invoice number"
this field has a number .. first card was 1, second 2, one hundreth 100, and so on up to the thousands eg 2347
I wrote a simple script "sort stack by bg field "invoice number"
I am getting a result where, for example, invoices 1,10,100 follow each other when the script has run.
or 979,99,980 follow each other
Whereas I want the stack ordered by usual numeric sequence eg 1,2,3 ..... 979,980,981.....
I am sure there is a simple answer and would be grateful for help.

sort stack numeric by bg fld "invoice number" -- should do the trick

On Fri, Jul 6, 2018 at 10:41 PM, drjohntas@[redacted].com[HyperCard] <
HyperCard-Mailing-List> wrote:

>
>
> Hi.. I am doing my end of year accounts. I have a Hypercard Invoice stack
> with various sort buttons.. eg "sort by client name" (brings same clients
> invoices together), or "sort by company" etc
>
> I want to bring stack back to original order so wrote a "sort by invoice
> number"
>
> Each invoice is on a separate card.
>
> Each card has a bg field called "invoice number"
>
> this field has a number .. first card was 1, second 2, one hundreth 100,
> and so on up to the thousands eg 2347
>
> I wrote a simple script "sort stack by bg field "invoice number"
>
> I am getting a result where, for example, invoices 1,10,100 follow each
> other when the script has run.
>
> or 979,99,980 follow each other
>
> Whereas I want the stack ordered by usual numeric sequence eg 1,2,3 .....
> 979,980,981.....
>
> I am sure there is a simple answer and would be grateful for help.
>
>
>
>

thanks .. silly me.. I stuck the word numeric in the wrong spot Can you help me do it in the reverse order so highest number first

-- probably; have not tried it
sort numeric descending by fld "invoice number"

On Fri, Jul 6, 2018 at 11:43 PM, drjohntas@[redacted].com[HyperCard] <
HyperCard-Mailing-List> wrote:

>
>
> thanks .. silly me.. I stuck the word numeric in the wrong spot
> Can you help me do it in the reverse order so highest number first
>
>
>
>

great.. that does it... thanks heaps

Try this on for size:

sort stack descending numeric by bg fld "invoice number"

You may find the following webpage, the complete BNF syntax of HyperTalk, to be of interest:

http://www.jaedworks.com/hypercard/scripts/hypertalk-bnf.html


"Bewitched" + "Charlie's Angels" - Charlie = "At Arm's Length"
Read the webcomic at [ http://www.atarmslength.net ;]!
If you like "At Arm's Length", support it at [ http://www.patreon.com/DarkwingDude ;].