XBasic IF statements

[hov333]

Re: XBasic IF statements

listbox.JPG

Its a listbox compiled from a filtered list of records matching the product part_number. So each product has its own matching shortcuts of parts to bring into the form.

I have another table which holds the shortcuts records and all the parts.

Maybe being able to do a multi-select would be better? This way the user can select multiple shortcuts. But most importantly, if they manually fill the field, I don't want the shortcut to over-write it but rather fill in the subsequent field.

[Stan Mathews]

Re: XBasic IF statements

So the listbox displays the values in a variable on the form? We can count the lines in the variable, if so. What's the name of the variable. Scop is layout, session, global?

[hov333]

Re: XBasic IF statements

Yes its a variable list, compiled by the matching records from my 'shortcuts' table. The result is stored as a Layout Variable "RS"

At the moment its just a list box, there was no option for multi-select list...I'm not sure how to implement a multi-select but maybe that will work better.

[Stan Mathews]

Re: XBasic IF statements

What's the filter expression for the listbox?

[hov333]

Re: XBasic IF statements

The filter compares the part_number field in my shortcut lookup table to the outgoing_part_number field in the master table. This way it only lists the shortcuts that are relevant for each particular product. The shortcut is selected via "nickname" field.

filter.JPG


See my lookup table below to be clear, I know "part number" has come up a lot in this conversation. In terms of my fields, "part_number" is referencing the product. And rpartnum/rpartdesc/rpartqty references the replacement/repair parts (components) if that makes sense. Up to 15 parts/components can be listed for each product being repaired.


table.JPG

[Stan Mathews]

Re: XBasic IF statements

We need to get the whole list that the listbox presents on screen into a variable so we can process each choice. The expression that should do that is

somevar = table.external_record_content_get("repair shortcuts","alltrim(part_number)","","part_number = "+quote(outgoing_part_number))

So try this in the interactive window (you can copy and paste from here) (use the enter key after each line)

outgoing_part_number = "enter_a_known_part_number_here"

? table.external_record_content_get("repair shortcuts","alltrim(part_number)","","part_number = "+quote(outgoing_part_number))

You should see Alpha return the part_numbers for the linked shortcuts

= sjfdljsdf
dfouu
uqwru
ldjfls

If that works we can proceed.

[hov333]

Re: XBasic IF statements

when typing the following in the interactive window:

outgoing_part_number = 2259976
? table.external_record_content_get("repair shortcuts","alltrim(part_number)","","part_number = "+quote(outgoing_part_number))

results in:
ERROR: Argument is incorrect data type

[hov333]

Re: XBasic IF statements

The goal is to list the shortcuts by fieldname "nickname" as shown in the previous screenshots. If you look there is a little listbox showing "2 cap 4 diode, 2 cap 4 diode + ECR"

This lists the shortcuts depending on the product. It seems to compile the list just fine based on the settings I've chosen but how would we convert this into a multi-select box instead of a single select listbox...

[Stan Mathews]

Re: XBasic IF statements

outgoing_part_number = "2259976"
? table.external_record_content_get("repair shortcuts","alltrim(part_number)","","part_number = "+quote(outgoing_part_number))

[Stan Mathews]

Re: XBasic IF statements

how would we convert this into a multi-select box instead of a single select listbox

Multi-select box is only available in xdialog.

[hov333]

Re: XBasic IF statements

outgoing_part_number = "2259976"
? table.external_record_content_get("repair shortcuts","alltrim(part_number)","","part_number = "+quote(outgoing_part_number))

I tried with the " " but still getting ERROR: Argument is incorrect data type

[Tom Cone Jr]

Re: XBasic IF statements

Pardon me for jumping in, but you guys are on post 26 and no sample data has been supplied, nor is it entirely clear there is agreement on what the question might be. May I suggest that John upload sample data, and that he use JING to create a short screencast explaining what he is shooting for. JING is available from the TechSmith website for free.

[Ray in Capetown]

Re: XBasic IF statements

Curved ball here !!!
I wouldn't want to see the method John is trying to use - in view of how I understand it.
It is doable, but overly complicated, restrictive and more..
The method is seriously unconventional

I see parts being picked and added to fixed fields for part, qty and price.
All the parts are fields within the header - in ONE RECORD, trying to work out which 3 fields to put the next part, by checking for the first three, free fields
It is a classic case for one to many parts used surely ?
Separate the 15 x 3 parts fields into a three field linked table

[hov333]

Re: XBasic IF statements

I think post 14 explains exactly what I need. Please take a look at the attachment in post 1 ('2 cap 4 diode' shortcut applied to empty fields) and compare to post 14 ('2 cap 4 diode' shortcut applied, AFTER a fan is listed as part1) - this is my goal. It may be complicated for whatever reason but it seems the logic behind it is pretty straight forward.

Logic: press selected "shortcut" to insert related shortcut parts into the parts fields...if the field is occupied (1st row in attachment of post 14), then fill the subsequent fields below with said shortcut. This will allow the user to manually enter data into the parts fields as well as apply numerous shortcuts one after another.

[Tom Cone Jr]

Re: XBasic IF statements

John, I for one am unable to decipher your posts. Rather than burn bandwidth here by repeating my previous suggestions, I'll climb back in the stands and watch as you and others grope towards an understanding of the problem and its solution.