How to move one row at a time in a browse

[oroma]

I would like to have button UP and another DOWN to move the current item up or down in the items of an invoice. In order to re arrange an invoice already create.

[Peter.Greulich]

Re: How to move one row at a time in a browse

Strictly speaking, you can't do what you want. A database is not a spreadsheet. Records are ordered by record number (the default), indices or queries. The problem with doing what you want is that you would need to use some serial value, numeric or character, and index it or query that field. Then using xbasic you would have to "swap" series value between two records, thus achieving the up & down effect. But if you wanted to move a row down three places for example, you would need to read/write all three + one records. It gets a little tricky. It's doable if you know xbasic a little.

[Stan Mathews]

Re: How to move one row at a time in a browse

Strictly speaking, you can't do what you want. A database is not a spreadsheet. Records are ordered by record number (the default), indices or queries. The problem with doing what you want is that you would need to use some serial value, numeric or character, and index it or query that field. Then using xbasic you would have to "swap" series value between two records, thus achieving the up & down effect. But if you wanted to move a row down three places for example, you would need to read/write all three + one records. It gets a little tricky. It's doable if you know xbasic a little.

I agree with Peter but why not just add a field to hold the invoice line number and have it designed with a simple default expression of some sort and let the user override it if they want to reorder the invoice?

[G Gabriel]

Re: How to move one row at a time in a browse

Oscar:
You could do that by:
a-Initialize an array from the table on which the browse is based.
b-In an array, moving a row up or down is a very simple matter
c-The tricky part comes when you try to print a report from an array. Recently, I was working on such routine, however due to time restrictions, I did not explore every possible means to do that and decided to simply append the array to a new table and print off the new table. Maybe someone else will have better ideas.

If arrays is not your thing, Here is another idea:

First, keep in mind that your browse could be simply based on the record number, but it might be based on an index, it might be sorted Ascending or Descending.., so moving a row up or down has to follow all these pre-defined parameters.

Let's say you have:
Row A
Row B
You want to move Row B above Row A

To bypass these pre-defined parameters, point to the row you want to move (Row B), then on a button that would move the row up write a script that:

1-move the pointer one row up: fetch_previous()
2-Duplicate the row above, now you have:
Row A
Row A
Row B

3-By doing that and on saving the browse, the new row will follow the filter and sort parameters you have in place (theoretically speaking. I did not try this before as I have not encountered this need but it's worth a try)

4-Send the fields' values of of Row B to variables
5-Move up two rows, change the fields' values of the first Row A to the variables' values
6-Go down two rows, delete the original Row B.

[G Gabriel]

Re: How to move one row at a time in a browse

Or... even yet.. a much simpler idea:

When on Row B: send Row B's values to variables
Move up to Row A and send Row A's values to another set of variables
Use the first set of variables (from Row B) to re-populate Row A
Move down and re-populate Row B with the group of Variables.

[oroma]

Re: How to move one row at a time in a browse

Thanks! for all the input, i will give it a try.

[oroma]

Re: How to move one row at a time in a browse

just for info, the idea behind is to permanently change the proforma-invoice items or a quote. For example we have quoted shirt1, shirt2, pants1, pants2, pants3 then the customer calls and wants to add shirt3, and shirt4, now these items will be below the pants and I will like to have all shirts to be first on the list and all pants to be last.

[Lance Gurd]

Re: How to move one row at a time in a browse

sorting invoice items on description would sort out this problem

[G Gabriel]

Re: How to move one row at a time in a browse

Here it is.

[oroma]

Re: How to move one row at a time in a browse

Thanks Gabriel, now I just how to figure how to keep moving the current record up or down as many times as I want to.
Thanks this is getting exciting to be able to do more that just creating a table.

[Mike Wilson]

Re: How to move one row at a time in a browse

Oscar,
In the Form Design Mode, there is the Menu option "Arrange> Set by example". This same action could be written into a button-based script that amends a field of the record for sorting the invoice. It follows along the ideas of what Peter and Stan wrote that you can visualize and see if this might be what you envision.

Mike W

[Lance Gurd]

Re: How to move one row at a time in a browse

Mike,

That is for arranging the tab order of the form, not the order of the records in a browse

[Mike Wilson]

Re: How to move one row at a time in a browse

Lance,
Yes, I know this. However it is a visual example of how a user generates an order based upon user selection that could be emulated in a script that amends a record field as a strategy to ordering/sorting the records in the invoice.

Mike W

[G Gabriel]

Re: How to move one row at a time in a browse

Oscar:
You could move it as many times as you want. See attached.

[MoGrace]

Re: How to move one row at a time in a browse

I started a similar thread over in Ver6 about how to trap the BOF or EOF in the browse. Gabriel's script does do the basic move UNTIL you get to the first or last row of the browse. I am watching this thread to see if you guys can figure it out! Perhaps Peter will come back and give us a hand!