[RBASE-L] - Re: Get Property

[Doug Hamilton]

Are you sure MODEL is getting posted to PRODUCT_NEW Table?  
Maybe put a BRO ALL FRO PRODUCT_NEW right after your ENTER to make sure the table is updated
Since you are out of the form, try an SQL  SELECT Order_Model into vModel....  instead of GETPROPERTY.

Doug


Jim Belisle wrote:

Often, our sales people have a need to enter a new product into the PRODUCT table while giving a quote.  This is due to a slight change in an already existing product.  I have a BIT button places on the detail line that will bring up the form. 

 

Now what I want to do is have specific fields entered into another table I have so I will know I have to format the new product.  I gave the MODEL field a component ID of Order_Model.  Here is the EEP that IS in the BIT button

 

SET VAR vFormMode = 'Enter'

ENTER USING KayParkProduct FOR 1 ROW

PROPERTY Order_Model REFRESHLIST TRUE

GETPROPERTY Order_Model TEXTVALUE vModel

INSERT INTO PRODUCT_NEW VALUES +

       (.vOrderID, .vModel, 'N', 'N', 'N', 'N', 'N', 'N', 'N', '-0-')

RETURN

 

I am able to enter the new item into the PRODUCT table.  The OrderID and all the other values are entered into the PRODUCT_NEW table

EXCEPT the model.  The field is blank in the table.

 

I know this is simple, but your help is appreciated.

 

Jim