Thanks, David. Answers below:
Regards,
Alastair.
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, March 09, 2005 2:00 PM
Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions:
a little localdifficulty
> Alastair
>
> It's still hard to picture what the issue is from your posting. I
> understand what you WANT, I dont' understand what is happening instead.
> Please respond yes/no or correct my misconceptions on the questions below
> and let's see if we can get clear on the issue.
>
> 1. First, Am I correct that there are 3 regions on the form?
Yes, but 4 tables.
>
> It's still hard to picture what the issue is from your posting. I
> understand what you WANT, I dont' understand what is happening instead.
> Please respond yes/no or correct my misconceptions on the questions below
> and let's see if we can get clear on the issue.
>
> 1. First, Am I correct that there are 3 regions on the form?
Yes, but 4 tables.
>
> 2. I THINK you are describing 2 separate problems.
>
> 1. In region 1, the resizing PROPERTY command is placed as part of an
> "On Row Entry" eep. It resizes when you ENTER the region, but if you
> change a row, then move to the next row it does NOT resize.
The resizing takes place correctly when starting the form but not on any subsequent row change from Table One. "Fred" is fine, "Joe" or "Mary" are not.
> 2. I THINK you are describing 2 separate problems.
>
> 1. In region 1, the resizing PROPERTY command is placed as part of an
> "On Row Entry" eep. It resizes when you ENTER the region, but if you
> change a row, then move to the next row it does NOT resize.
The resizing takes place correctly when starting the form but not on any subsequent row change from Table One. "Fred" is fine, "Joe" or "Mary" are not.
>
> You wrote: "If I move the EEP to the displayed variable's "On Entry"
> EEP when I click on the variable the display is updated." This makes no
> sense to me. I hear the words but not the meaning.
> You wrote: "If I move the EEP to the displayed variable's "On Entry"
> EEP when I click on the variable the display is updated." This makes no
> sense to me. I hear the words but not the meaning.
To me, the logical place for the EEPs are
in the table(s) "On Row Entry".
However, putting the EEP for
the first table in the displayed variable allows me to click on the
variable and effect the change to the size for the first region _after_ changing
rows for the first table. So, start with Fred then move to Joe and clicking on
Joe changes the display for Joe's first region. I can't get this region to
resize without clicking or tabbing to "activate" the EEP - wherever I place
it
>
> 2. In regions 2 and 3, the sizing IS taking place as you want it to,
> but that the cursor is not resting on the first row after the eep runs.
I can get the cursor to rest in the first row but not to activate the EEP for that table without clicking in each region first.
>
> 2. In regions 2 and 3, the sizing IS taking place as you want it to,
> but that the cursor is not resting on the first row after the eep runs.
I can get the cursor to rest in the first row but not to activate the EEP for that table without clicking in each region first.
>
> This is not clear: there IS NO CURSOR in regions 2 and 3, because
> you're resting in region 1 according to your description. Do you mean you
> want the cursor in REGION 1 to return to the top of the region?
You're right. The cursor is in either the first table's variable or in the first region but the other 2 regions have a "highlighted" row. I can make these the first rows ok but still not get the EEP associated with the table for the region to run until I click in the region's fields.
> This is not clear: there IS NO CURSOR in regions 2 and 3, because
> you're resting in region 1 according to your description. Do you mean you
> want the cursor in REGION 1 to return to the top of the region?
You're right. The cursor is in either the first table's variable or in the first region but the other 2 regions have a "highlighted" row. I can make these the first rows ok but still not get the EEP associated with the table for the region to run until I click in the region's fields.
>
> Try to answer these, but I suspect you may end up having to send this to
> RBTI for their assistance!
> Try to answer these, but I suspect you may end up having to send this to
> RBTI for their assistance!
I suppose you could say that I'm trying to
get something like a series of mythical property commands following moving
between rows in "Table One" that might be:
Press [F8] or DB-Navigator for Table
One
PROPERTY
TABLE One RUN T1-On_Entry_EEP -- re-size table 2/region
1
SKIP TO Table Two
SKIP TO Table Two
PROPERTY TABLE Two
FIRST
-- go to first row table 2
PROPERTY
TABLE Two RUN T2-On_Entry_EEP -- re-size table 3/region
2
SKIP TO Table Three
PROPERTY TABLE Three
FIRST -- go to first row table
3
PROPERTY TABLE Three RUN T3-On_Entry_EEP -- re-size table 4/region 3
PROPERTY TABLE Four FIRST -- place the highlight on the first row of the last region.
PROPERTY TABLE Three RUN T3-On_Entry_EEP -- re-size table 4/region 3
PROPERTY TABLE Four FIRST -- place the highlight on the first row of the last region.
I hope that's a little clearer - it's
really hard to put into words. The purple commands are what I can't get to run
automatically. The EEPs run perfectly if I click into the regions
concerned.
>
> David
>
> David Blocker
> [EMAIL PROTECTED]
> 781-784-1919
> Fax: 781-784-1860
> Cell: 339-206-0261
> ----- Original Message -----
> From: "Alastair Burr" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List" <[email protected]>
> Sent: Wednesday, March 09, 2005 3:58 AM
> Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> difficulty
>
>
> > I'm still not able to resolve the problem of getting an automatic
> "refresh"
> > of the scrolling regions in the lower tables of my form.
> >
> > As nobody has responded to my original question on this particular part of
> > the problem let me ask it in a different way:
> >
> > If I use an "On Row Entry" EEP for the driving table then the first
> > scrolling region displays correctly sized on running the form. However,
> > moving to subsequent rows in the driving table doesn't update the size via
> > the EEP. If I move the EEP to the displayed variable's "On Entry" EEP when
> I
> > click on the variable the display is updated.
> >
> > What is stranger is that for the second and third scrolling regions their
> > display is updated as I want when clicking on any row from the preceding
> > scrolling region(s) with the EEP placed as a table "On Row Entry" one.
> >
> > What I'm trying to program is for the first scrolling region to resize
> based
> > on changing rows in the driving table and the subsequent scrolling regions
> > to change size either based on the first row or the currently selected
> row.
> > More logically, I think, is for all the scrolling regions to return to the
> > first row when the driving table row is changed. However, no combination
> of
> > skip and property commands that I've tried seems to move the selected row
> to
> > the first and run the "On Row Entry" for its driving table.
> >
> > The re-sizing works fine - and looks great - but I want to avoid the mouse
> > clicks needed to update the displays that I seem to require at the moment
> to
> > activate the EEP.
> >
> > Has anybody any ideas what I'm doing wrong?
> >
> > For example:
> >
> > The driving table is on the row "Fred". There are 2 rows associated with
> > Fred in the first s/r so that needs 2 rows displayed. For the first of
> those
> > rows there are 3 rows in the second s/r and for the second row there are
> 10
> > rows in the second s/r. The second s/r needs to re-size to either 2 rows
> or
> > 10 rows depending on which row in the first s/r is selected. The third s/r
> > needs to re-size depending on the number of rows associated with the
> current
> > row in s/r number 2.
> >
> > When moving to the row "Joe" there might be 10 rows to display for the
> first
> > s/r and the relevant numbers of rows for the subsequent s/r's depending on
> > which row is selected.
> >
> > It's this change that I'm trying to get to work with the first row of each
> > of the 3 s/r's selected or active without having to click anywhere.
> >
> > By the way, concerning the "Invalid Text" problem, I attempted using an
> > additional column and using SRPL to replace any single quotes in my views
> > but this slowed the response dramatically. If I had thought about it first
> I
> > might have realised that the view had to calculate all the SRPLs before
> the
> > links could be made. I now use temp tables and insert the basic data with
> a
> > computed column to do the SRPL. Naturally, this is very fast and solves
> the
> > "Invalid Text" error. Thanks again, Albert.
> >
> > Regards,
> > Alastair.
> >
> > ----- Original Message -----
> > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > To: "RBG7-L Mailing List" <[email protected]>
> > Sent: Monday, March 07, 2005 9:12 PM
> > Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> > difficulty
> >
> >
> > > Thanks, Albert, it's strange that I haven't noticed it before but I've
> > > always tried to link on IdNums of some sort so perhaps I've just been
> > > fortunate.
> > >
> > > Happily, though, the form is based on views so, with luck, I can add a
> > > computed column that does a trick or two, link on those and rename the
> > other
> > > links.
> > >
> > > Regards,
> > > Alastair.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Albert Berry" <[EMAIL PROTECTED]>
> > > To: "RBG7-L Mailing List" <[email protected]>
> > > Sent: Monday, March 07, 2005 6:26 PM
> > > Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> > > difficulty
> > >
> > >
> > > > Alastair, I have some databases that use double quotes because of this
> > > problem with single quotes
> > > > in name fields such as "O'Brien". You have to somehow double up the
> > quote
> > > in the linking field so
> > > > it takes the quote as a literal character rather than a quote, which
> > > terminates the text field
> > > > prematurely.
> > > >
> > > > Yes, the SQL standard is single quotes, but No, it's not the best
> thing
> > > going in some cases. The
> > > > hoops jumped through to get fields with apostrophes in them to work
> can
> > be
> > > eliminated very simply
> > > > by using double quotes.
> > > >
> > > > SET FLAME_PROOF_UNDERWEAR ON
> > > >
> > > >
> > > > --- Alastair Burr <[EMAIL PROTECTED]> wrote:
> > > > > I have a form based on 4 tables. The driving table simply returns a
> > > looked-up name with the
> > > > > other 3 tables each returning a scrolling region based on the
> > preceding
> > > table.
> > > > >
> > > > > I have been attempting to dynamically size the scrolling regions to
> > > return the number of rows
> > > > > found for each table.
> > > > >
> > > > > I have the maths working fine and each one works individually but I
> > have
> > > two things which I
> > > > > haven't found a solution for yet:
> > > > >
> > > > > Firstly, I seem to have to click into each region to get it to
> adjust
> > > its size; and
> > > > > secondly: there is a lot of flashing of the screen as each one is
> > > changed.
> > > > >
> > > > > I've tried every combination of Set_Focus and Skip To and table
> > > properties for First, Refresh,
> > > > > Recalc, etc that I can think of but not found the missing
> ingredient.
> > > > >
> > > > > One other thing that is related to scrolling regions but not
> > > particularly to this form - as far
> > > > > as I know - is that I am getting some "Invalid Text Value" error
> > > messages - apparently -
> > > > > whenever the linking (text) columns contain a single quote (as an
> > > apostrophe). Is this something
> > > > > that needs to be reported as a bug (upgrade #80/RC2)?
> > > > >
> > > > > Thanks & regards,
> > > > > Alastair.
> > > > >
> > > > > ----------------------------------
> > > > > A D B Burr,
> > > > > St. Albans, UK.
> > > > > ----------------------------------
> > > > > [EMAIL PROTECTED]
> > > > > ----------------------------------
> > > >
> > > > Albert Berry
> > > > Management Consultant
> > > > RR2 - 1252 Ponderosa Drive
> > > > Sparwood BC, V0B 2G2
> > > > Canada
> > > > (250) 425-5806
> > > > (250) 425-7259
> > > > (708) 575-3952 (fax)
> > > > [EMAIL PROTECTED]
> > > >
> > >
> >
> > --- RBG7-L
> > ================================================
> > TO POST A MESSAGE TO ALL MEMBERS:
> > Send a plain text email to [email protected]
> >
> > (Don't use any of these words as your Subject:
> > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
> > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: INTRO
> > ================================================
> > TO UNSUBSCRIBE:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: UNSUBSCRIBE
> > ================================================
> > TO SEARCH ARCHIVES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: SEARCH-n
> > (where n is the number of days). In the message body,
> > place any
> > text to search for.
> > ================================================
> >
> >
>
> David
>
> David Blocker
> [EMAIL PROTECTED]
> 781-784-1919
> Fax: 781-784-1860
> Cell: 339-206-0261
> ----- Original Message -----
> From: "Alastair Burr" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List" <[email protected]>
> Sent: Wednesday, March 09, 2005 3:58 AM
> Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> difficulty
>
>
> > I'm still not able to resolve the problem of getting an automatic
> "refresh"
> > of the scrolling regions in the lower tables of my form.
> >
> > As nobody has responded to my original question on this particular part of
> > the problem let me ask it in a different way:
> >
> > If I use an "On Row Entry" EEP for the driving table then the first
> > scrolling region displays correctly sized on running the form. However,
> > moving to subsequent rows in the driving table doesn't update the size via
> > the EEP. If I move the EEP to the displayed variable's "On Entry" EEP when
> I
> > click on the variable the display is updated.
> >
> > What is stranger is that for the second and third scrolling regions their
> > display is updated as I want when clicking on any row from the preceding
> > scrolling region(s) with the EEP placed as a table "On Row Entry" one.
> >
> > What I'm trying to program is for the first scrolling region to resize
> based
> > on changing rows in the driving table and the subsequent scrolling regions
> > to change size either based on the first row or the currently selected
> row.
> > More logically, I think, is for all the scrolling regions to return to the
> > first row when the driving table row is changed. However, no combination
> of
> > skip and property commands that I've tried seems to move the selected row
> to
> > the first and run the "On Row Entry" for its driving table.
> >
> > The re-sizing works fine - and looks great - but I want to avoid the mouse
> > clicks needed to update the displays that I seem to require at the moment
> to
> > activate the EEP.
> >
> > Has anybody any ideas what I'm doing wrong?
> >
> > For example:
> >
> > The driving table is on the row "Fred". There are 2 rows associated with
> > Fred in the first s/r so that needs 2 rows displayed. For the first of
> those
> > rows there are 3 rows in the second s/r and for the second row there are
> 10
> > rows in the second s/r. The second s/r needs to re-size to either 2 rows
> or
> > 10 rows depending on which row in the first s/r is selected. The third s/r
> > needs to re-size depending on the number of rows associated with the
> current
> > row in s/r number 2.
> >
> > When moving to the row "Joe" there might be 10 rows to display for the
> first
> > s/r and the relevant numbers of rows for the subsequent s/r's depending on
> > which row is selected.
> >
> > It's this change that I'm trying to get to work with the first row of each
> > of the 3 s/r's selected or active without having to click anywhere.
> >
> > By the way, concerning the "Invalid Text" problem, I attempted using an
> > additional column and using SRPL to replace any single quotes in my views
> > but this slowed the response dramatically. If I had thought about it first
> I
> > might have realised that the view had to calculate all the SRPLs before
> the
> > links could be made. I now use temp tables and insert the basic data with
> a
> > computed column to do the SRPL. Naturally, this is very fast and solves
> the
> > "Invalid Text" error. Thanks again, Albert.
> >
> > Regards,
> > Alastair.
> >
> > ----- Original Message -----
> > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > To: "RBG7-L Mailing List" <[email protected]>
> > Sent: Monday, March 07, 2005 9:12 PM
> > Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> > difficulty
> >
> >
> > > Thanks, Albert, it's strange that I haven't noticed it before but I've
> > > always tried to link on IdNums of some sort so perhaps I've just been
> > > fortunate.
> > >
> > > Happily, though, the form is based on views so, with luck, I can add a
> > > computed column that does a trick or two, link on those and rename the
> > other
> > > links.
> > >
> > > Regards,
> > > Alastair.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Albert Berry" <[EMAIL PROTECTED]>
> > > To: "RBG7-L Mailing List" <[email protected]>
> > > Sent: Monday, March 07, 2005 6:26 PM
> > > Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local
> > > difficulty
> > >
> > >
> > > > Alastair, I have some databases that use double quotes because of this
> > > problem with single quotes
> > > > in name fields such as "O'Brien". You have to somehow double up the
> > quote
> > > in the linking field so
> > > > it takes the quote as a literal character rather than a quote, which
> > > terminates the text field
> > > > prematurely.
> > > >
> > > > Yes, the SQL standard is single quotes, but No, it's not the best
> thing
> > > going in some cases. The
> > > > hoops jumped through to get fields with apostrophes in them to work
> can
> > be
> > > eliminated very simply
> > > > by using double quotes.
> > > >
> > > > SET FLAME_PROOF_UNDERWEAR ON
> > > >
> > > >
> > > > --- Alastair Burr <[EMAIL PROTECTED]> wrote:
> > > > > I have a form based on 4 tables. The driving table simply returns a
> > > looked-up name with the
> > > > > other 3 tables each returning a scrolling region based on the
> > preceding
> > > table.
> > > > >
> > > > > I have been attempting to dynamically size the scrolling regions to
> > > return the number of rows
> > > > > found for each table.
> > > > >
> > > > > I have the maths working fine and each one works individually but I
> > have
> > > two things which I
> > > > > haven't found a solution for yet:
> > > > >
> > > > > Firstly, I seem to have to click into each region to get it to
> adjust
> > > its size; and
> > > > > secondly: there is a lot of flashing of the screen as each one is
> > > changed.
> > > > >
> > > > > I've tried every combination of Set_Focus and Skip To and table
> > > properties for First, Refresh,
> > > > > Recalc, etc that I can think of but not found the missing
> ingredient.
> > > > >
> > > > > One other thing that is related to scrolling regions but not
> > > particularly to this form - as far
> > > > > as I know - is that I am getting some "Invalid Text Value" error
> > > messages - apparently -
> > > > > whenever the linking (text) columns contain a single quote (as an
> > > apostrophe). Is this something
> > > > > that needs to be reported as a bug (upgrade #80/RC2)?
> > > > >
> > > > > Thanks & regards,
> > > > > Alastair.
> > > > >
> > > > > ----------------------------------
> > > > > A D B Burr,
> > > > > St. Albans, UK.
> > > > > ----------------------------------
> > > > > [EMAIL PROTECTED]
> > > > > ----------------------------------
> > > >
> > > > Albert Berry
> > > > Management Consultant
> > > > RR2 - 1252 Ponderosa Drive
> > > > Sparwood BC, V0B 2G2
> > > > Canada
> > > > (250) 425-5806
> > > > (250) 425-7259
> > > > (708) 575-3952 (fax)
> > > > [EMAIL PROTECTED]
> > > >
> > >
> >
> > --- RBG7-L
> > ================================================
> > TO POST A MESSAGE TO ALL MEMBERS:
> > Send a plain text email to [email protected]
> >
> > (Don't use any of these words as your Subject:
> > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
> > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: INTRO
> > ================================================
> > TO UNSUBSCRIBE:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: UNSUBSCRIBE
> > ================================================
> > TO SEARCH ARCHIVES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: SEARCH-n
> > (where n is the number of days). In the message body,
> > place any
> > text to search for.
> > ================================================
> >
> >
>
