Process multi-select listbox data

[dik_coleman]

Attached is a zip of the test database.
Customer set contains customer data and customer item data.
Customer and Items are linked by customer id.

Transaction set is used to record sales data by customer and customer item.
Each customer item is to be listed as a line item (separate table) of the transaction table.
Transaction table and Line Item table are linked by transaction id.

Chosing items with the multi-select box, and displaying choices made is relatively easy.

How do you transfer the choices from memory to variables?

In my example, the choices are contained in 'work_list'.
I have not (yet) been able to find a way to get the data into a workable form to create the line item list for each transaction.

Any help will be appreciated.
D

[Peter.Greulich]

RE: Process multi-select listbox data

Richard:

First, COMPLAINT:
Like many people, you post a sample db, with no instructions on where to look. I assume you are referring to the single global script. My complaint is, that you make it a little hard for someone to help you. End of complaint.

Second, SOLUTION:

Put this code after (or instead of) your ui_msg_box:

vListCount = w_count(work_list,crlf())
Dim vWord[vListCount] as C
For i = 1 to vListCount
vWord[i] = word(work_list,i,crlf())
traceln(vWord[i])
next

Then look at the trace window.

Peter

[dik_coleman]

RE: Process multi-select listbox data

Thanx for the reply.
Sorry -- for the misunderstanding
for not being more explicit
for the fact that I still need help.

Your solution does not solve my problem. As far as I can ascertain, putting the chosen items into an array does not allow me to use these array items.
Obviously, I am missing something.

To be more to the point, the procedure is:
1)look up a customer by name
2)chose one or more of the items using the multi-select list box.
3) transfer each of the chosen items to global variables so that
they can then be 'processed' individually into the sales transaction as a line item.
4) there are other fields in the customer item table that contain data to be used in the sales transaction
such as cost, sales tax, etc...

So, I need to be able to 'look at' each chosen item, enter it into a new record in the
transaction line item table, add more data from the customer item
table, and then start totalling up the sales transaction.

All of these things I can now do manually or if there is only one customer item
to be processed. I need the multiple items in a form that I can use to re-access the
customer table, the customer item table, and make new records in the transaction table
and the transaction line item table.
I have tried to access each 'chosen item' while in array form, but keep getting errors.
If you can give me some idea of what I am missing and where to look, I would appreciate it.

D

[Peter.Greulich]

RE: Process multi-select listbox data

Ok, Richard,

I responded to item no. 3. See attached.

When the app opens, press the red "Select" button. Let me know if this gets you going in the right direction.

Peter

[dik_coleman]

RE: Process multi-select listbox data

OK thanx.
We're about 80% but most of the grunt work is done.
Take a look at the way I've changed your recommendation.
The problems encountered were that the previous choices in the list box would carry over to the next request, even if you left the form; and the transfer variables would retain the last choices ....

Both are fixed and it seems to work great.

the last 20% is being able to use the choice to go back to the item table and start transferring data from that table to the transaction line item table.

Your use of 'evaluate_template' led me to 'code indirection' and maybe the answer lies there. I will update you if and when I either solve it or go crazy.

Look at the comments in the 'pick_items' script for the changes that I made.

thank you very much
D

[Peter.Greulich]

RE: Process multi-select listbox data

The problems encountered were that the previous choices in the list box would carry over to the next request, even if you left the form; and the transfer variables would retain the last choices ....

Because both are defined as global variables


the last 20% is being able to use the choice to go back to the item table and start transferring data from that table to the transaction line item table.

I'm not 100% following you. After you get the global vars assigned, which table do you want to stuff those values into?

That is easy to do. Let me know, and I will amend the code accordingly.

Peter

[dik_coleman]

RE: Process multi-select listbox data

I knew why the global vars were not clearing.
In the 'real app' they need to be cleared before each use.
So, I made that correction.

In regard to which table the data is destined...
that would be the transaction line item table..

The system is a bit complex. Everything is based on the customer appointment. As the appointment is made, all tables are 'updated' and the sales transaction is 'filled out'. There are pricing and workload factors that are contained in the customer item table that need to be 'stuffed' into the transaction table and the transaction line item table. In essence, the 'sales slip' is pre-made and ready for the future customer arrival.

That means that once the customer is chosen, the customer item is picked and the date is chosen; the sales transaction is basically complete -- needing only the amount and type of payment to be filled in, as the customer picks up the item on the transaction completion date.

I already have a working model of this system, but it only allows for one choice to be made. I need this 'revision' in order to accomodate multiple choices.

Thanx for the direction and your help. Updates later....
D

[Peter.Greulich]

RE: Process multi-select listbox data

Richard,

I moved the button to your tax form and I changed the code a little. I'm not sure if this is what you want, but in this case as I understand it, you really don't even need global variables - local will do. Anyway, FWIW...

-Peter