Razzak,
Actually, I went over that form with John Minyo the other day for a different reason - that is quite the complex form and works pretty well. The only confusion I had on this particular issue was I was trying to put a lookup variable into a "variable label" as an informational label only. That just doesn't work for some reason, the region doesn't scroll, it stays on one line. Using a "Variable edit" accomplishes the goal with read only checked. I don't think it is a bug, just more likely an anomoly of a scrolling region.
Now, for those on the list, that particular form seems to represent a very popular scenario with many uses. I was quite impressed when John showed me some of the intricacies of the features that make this work.
Bob C.
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
[EMAIL PROTECTED] (RBG7-L
Mailing List)
cc:
Subject:
[RBG7-L] - Re:
Scrolling Region Oddity
At 04:41 PM 7/16/2004 -0400, Bob Castanaro wrote:
>I have been trying to easily create a data entry form with a
>scrolling region based on a table (enter formname). If I have
>DBEdits only in the region, the rows show up and it properly
>scrolls down to the next row after data has been entered in
>the last field in the row. I can see all the rows I have
>entered.
>If I have a lookup variable located in the region, it shows
>the lookup, still saves the row, but all the data disappears
>and it starts all over in the first field in the first row.
>Is this normal behavior for this, or am I forgetting to do
>something to make this work?
Bob Castanaro and Claudine Robbins:
Running R:BASE Your Way! (Part 5 through 11) includes a
"SalesOrder" form with "Scrolling Region" having DBEdit
as well as Variable Edit (lookup) controls.
Do you see the same oddity (as you have described above)
using the SalesOrder form?
To test the same scenario:
01. Start RBG7.1 (Update 76 or higher)
02. Switch the default working directory to:
C:\RBTI\RBG7\Samples\Databases\RRBYW8
03. Database Explorer > Command Files > RRBYW8.DAT > Run
04. RRBYW8 Main Menu > Sales > New Sales Order(s)
Select the appropriate information for the "Sales Header"
(Sales Rep, Bill To, Ship To, etc.)
05. For Line Item and Details ... click on "Line No."
. Notice the automated number for the first line item
. Double-click on Model and select the appropriate Product
(Notice the look-ups for Product Name, Location,
List Price)
. Enter Discount(%) if necessary
. Enter Qty and press [Enter]
(Notice the calculated "Extended Price"
as well as the
position of the cursor on the next line with automated
Line No.)
06. Repeat step 05 for at least four or five times
Do you see any oddity there?
Does the data disappear and does it start all over in the
first field?
To understand the scenario:
01. Start RBG7.1 (Update 76 or higher)
02. Switch the default working directory to:
C:\RBTI\RBG7\Samples\Databases\RRBYW8
03. Database Explorer > Command Files > GlobalVars > Run
Database Explorer > Command Files > TempTbls >
Run
04. Database Explorer > Forms > Sales Order > Design
. Take a look at all DB Edit and Variable Edit controls
including the properties of all DB Edit and Variable
Edit controls
. Also, take a look at Scrolling Region Properties:
(Table Name and Tiers)
Hope that helps you understand!
Very Best R:egards,
Razzak.
