At 03:53 PM 2/10/2005, Marc Shluter wrote:
4) I can get the first row to work but when I enter the 2nd row
the vPrice and vEstPrince in the first row changes to the values
of the 2nd row.
Marc,
The lookup values for column/variable defined as expression,
are true lookup values in R:BASE 7.x/V-8 "Turbo" and cannot
be overwritten.
A few options:
=================================
A. Using the classic EEP method:
=================================
To achieve the old functionality (as in 6.5++), you'll need
to define all lookup values as expressions, etc., in an EEP
(Entry/Exit Procedure) for column(s)/variable(s).
To understand this process and the correct logic, take a
look at the "Sales Order" routines of Running R:BASE Your
Way! (Part 8 or Part 9).
Database: RRBYW8 or RRBYW9
Associated Form: SalesOrder
Here's how:
01. Start RBG7
02. Switch the working directory to RRBYW8
03. CONNECT RRBYW8
04. RUN RRBYW8.DAT
05. RRBYW8 Main Menu | Sales | New Sales Order(s)
- Select Transaction Date
- Select Sales Rep
- Select Customer
Notice the "Bill To:" and "Ship To:" addresses
- You should be able to change these addresses, if you
wish.
06. Click on the "Line No." column and notice the automated
Line No.
07. Double-click on the "Model" column and select any model
from the Pop-up menu.
Notice the true lookups for:
. Product Name
. Location
. List Price
08. Enter 10 for the "Discount %".
09. Enter 2 for the "Quantity" and press [Enter]
Notice the calculated "Extended Price" and automated line
number for the next row.
Also, note the Sub-Total, Freight Charges, Sales Tax and
Invoice Total.
10. Click on [Continue] button.
11. Click on [Yes] to "Print Invoice?" dialog box.
12. Select Screen for the report output and click on Continue.
13. Notice the appropriate Billing and Shipping Addresses
as modified in Sales Order form.
==========================================
B. Using the GETPROPERT/PROPERTY Commands:
==========================================
01. Follow the suggestions posted by fellow list members.
02. http://www.rbase.com/getproperty
03. http://www.rbase.com/property
04. Read FormProperties.pdf
05. R:Docs
Hope that helps!
Should you require further assistance, feel free to ask.
Very Best R:egards,
Razzak.
