I have an edit table that has several symbolic fields in it one, the code follows returns null values when I get the invalue or array property of the table. The other symbolics work fine. The one in question displays on the screen just fine AND when I trigger the debugger and look at the array properties in the debugger the values that I want are there. The problem is that I can't get anything but the null values in an RBasic program.

Symbolic code

MV=@MV

QUANTITY_ORDERED_LIST=@Record

QUANTITY_BACK_ORDERED_LIST=@Record

QUANTITY_BACK_ORDERED_CXL_LIST=@Record

Delivery_List=@Record

ITEMS=COUNT(QUANTITY_ORDERED_LIST,@VM) + (QUANTITY_ORDERED_LIST NE ) ANS=' IF Delivery_List NE THEN

 FOR LUP1=1 TO ITEMS

   TMP=QUANTITY_ORDERED_LIST - (QUANTITY_BACK_ORDERED_LIST + QUANTITY_BACK_ORDERED_CXL_LIST)

   ANS=TMP

 Next Lup1

End Else

 For Lup1=1 to ITEMS

   ANS='

 Next Lup1

End

@ANS=ANS

Any help would be appreciated.

Steve,

I don't understand how you are calling this code from a Basic+ procedure. You said the symbolic works fine in the form, correct? But you also said you get null values when using the INVALUE or ARRAY property. You don't show how you are using those properties so I don't have anything to compare against.

[email protected]

SRP Computer Solutions, Inc.

This code is in another symbolic in the same table going to the same edit table. Both symbolics return values properly in the form. Both present properly in the properties view of array in the debugger but the one I copied the code to won't return anything but null values spaced by @VM in the result of a get_property(CtrlEntId,'ARRAY')

Does that help?

Steve,

I think I get it. I am very skeptical that the symbolic code has anything to do with the problem. What happens if you use alternative properties, e.g. LIST, DEFPROP, or INVALUE? What happens when you do a Send_Message/TEXT_BY_POS command for this column?

[email protected]

SRP Computer Solutions, Inc.

I tried defprop and invalue. Same results. I didn't try text_by_pos. I am trying to read the entire edit table of about 12 fields. It is a mixture of symbolics and fields. What is really interesting in my opinion is that in the properties returned by the debugger the column in question is populated. It is just in the presentation back to me from the array or invalue. (They both return the same result.) Because I am getting the entire edit table and only one column is different I was led to look at the code in the symbolic. What specifically is different from one of the others is that @ANS is populated using @MV or a value set by it. I appreciate you looking at this. I have spent some time with it and am starting to believe that it is a glitch of some sort related to the executed code. Why is it presenting properly in the properties view of the array in the debugger. (This is the one window that is not selected by default.)

Steve,

What's this?

@ANS=ANS

Shouldn't this be

@ANS=ANS

?

(I seem to remember this is how we did it Arev, letting the symbolic set individual mv values. It's a long time since I used Arev. I don't remember much of it.)

- Oystein -

I don't know which way is correct but I did try both of them and they return the same result. This one is really interesting.

For grins I tried this…..

QtyList=Get_Property(@Window:'.INVENTORY_TBL','INVALUE',8:@FM:0)

Array =Strip(Get_Property(@Window:'.INVENTORY_TBL','INVALUE'))

CATEGORY_LIST =Array

STORE_PN_LIST =Array

VENDOR_PN_LIST =Array

DESC_LIST =Array

SIZE_LIST =Array

COLOR_LIST =Array

QTY_LIST =Array

UNIT_COST_LIST =Array

EXT_COST_LIST =Array

Both qtylist and qty_list contain a string of @VM and no data. Remember that data is in the properties view of the form in I break to the debugger.

I have a snap shot of the debugger showing the presence of the values I am trying to retireve. I can post it if someone will tell me how

Steve,

I'm certain my version is right and yours is wrong. In OI the formula for a multi-valued field should produce the whole value, i.e, a @VM-delimited array. I seem to remember it was different in Arev, and that when I switched to OI I made mistakes because of this difference.

How are your other symbolics?

Is this problematic symbolic of yours based on other symbolics?

Another question: Is the problematic column really bound to the field? It might sound like a stupid question, but it should be easy to check.

- Oystein -

Steve,

You need to put the image file (the snapshot) on a web server, and then make a posting that refers to that file with an html img src tag. And the html tags you use must be enclosed in square brackets. That's how you can have html coding in postings on these lists.

But the first question is: Have you got a web server?

(If you haven't, and you're really eager to publish that screen dump, you can mail me the file on . I can then put it on my own web server, and make a posting that refers to it. But I can't do all this until 9-10 hours from now. It's midnight here now, I'm at home, and can't do it until I'm at work tomorrow morning.)

- Oystein -

I found it. It seems that if I use the following

Array=Strip(Get_Property @Window:'.INVENTORY_TBL','INVALUE',0:@FM:0))

It works fine.

Array =Strip(Get_Property(@Window:'.INVENTORY_TBL','INVALUE'))

Like the latter if brings in all of the fields, including other symbolics but not my qty column.

I thought 'INVALUE', 'DEFPROP', 'ARRAY' worked the same if you left off the col & Row. Remember I had this problem with all three of the above.

Thanks for all your help. Oystein, I appreciate your offer to post that dump.

I still think that rev should take a look at this one. It should either fail altogether or work correctly.

View this thread on the forum...