Detail Blocks

[JD Kromkowski]

I’ve finally gotten the time to look at 1.3. Here is a curious (bug?) regarding detail blocks. I have table “employees”, basic info about each employee: SSN, Name, etc. I have table “wages”, basic time sheet: SSN, Date, TimeStart, TimeEnd I create a detail block on a form consisting of Date, TimeStart, TimeEnd, as follows (same way I do it SB): Put each field on. Make a nice row properly aligned and distributed. Select all of these fields and then click on Define:Detail Blocks. Let’s say ten rows down. Every thing basically works, except for the following “niggles”. 1. I make the graphic properties of the initial detail block row with a yellow background (e.g.) so that it will be visually distinct from Employee fields which have standard gray background. So, in theory, all of the detail block rows should inherent that graphic property. Well, they sort of do but sort of don’t. In the form designer, the rows stay standard gray background, while the initial row is yellow background as designed. In the actual form view, rows which have data are yellow but the remaining rows are standard gray. So, if I have 10 rows in the block, but for a particular master record I only have 5 linked records, only the five with data are yellow background as designed, the empty rows are gray background. I think I know how to fix this manually but is this really the way it should work? 2. Second problem is even weirder. In record view, and in the table properties I have the following display formats. date: mm/dd/yyyy starttime: hh:mm am endtime: hh:mm am And in record view this is how they display but in the form, they look like this: first row: dd/MMM/yyyy hh:mm:ss hh:mm:ss second row mm/dd/yyyy hh:mm am hh:mm am 3rd row: mm/dd/yyyy hh:mm am hh:mm am Then I close everything down and restart Personal. Choose the form and the display is now as expected. BTW, I don’t this the table properties modify display format is working right, either.

[Michael]

On 09/04/2010 22:44, JDK wrote:
> I've finally gotten the time to look at 1.3.
>
> Here is a curious (bug?) regarding detail blocks.
>
> I have table "employees", basic info about each employee: SSN, Name,
> etc. I have table "wages", basic time sheet: SSN, Date, TimeStart,
> TimeEnd
>
> I create a detail block on a form consisting of Date, TimeStart,
> TimeEnd, as follows (same way I do it SB):
>
> Put each field on. Make a nice row properly aligned and distributed.
> Select all of these fields and then click on Define:Detail Blocks.
> Let's say ten rows down.
>
> Every thing basically works, except for the following "niggles".
>
> 1. I make the graphic properties of the initial detail block row with
> a yellow background (e.g.) so that it will be visually distinct from
> Employee fields which have standard gray background.
>
> So, in theory, all of the detail block rows should inherent that
> graphic property. Well, they sort of do but sort of don't.
>
> In the form designer, the rows stay standard gray background, while
> the initial row is yellow background as designed.
>
> In the actual form view, rows which have data are yellow but the
> remaining rows are standard gray. So, if I have 10 rows in the
> block, but for a particular master record I only have 5 linked
> records, only the five with data are yellow background as designed,
> the empty rows are gray background.
>
> I think I know how to fix this manually but is this really the way it
> should work?

Actually, the rows that have no data are disabled. The visual effect of
being disabled with native controls is that it looks gray.

> 2. Second problem is even weirder.
>
> In record view, and in the table properties I have the following
> display formats.
>
> date: mm/dd/yyyy starttime: hh:mm am endtime: hh:mm am
>
> And in record view this is how they display but in the form, they
> look like this:
>
> first row: dd/MMM/yyyy hh:mm:ss hh:mm:ss second row
> mm/dd/yyyy hh:mm am hh:mm am 3rd row: mm/dd/yyyy hh:mm
> am hh:mm am
>
> Then I close everything down and restart Personal. Choose the form
> and the display is now as expected.

So what you are saying is that after creating the controls via the form
designer, they already have the wrong display format, but the correct
one is apparently being inherited for the remainder of the detail block.
Loading the form later resolves the issue. That sounds like at some
point the default setting for dates is being used, and then later it is
not being overridden for the original control, but on load it get's
corrected. When you created the control originally, did you assign a
field to it, or did you add the field assignment afterward? Not saying
you did, just trying to figure out how this happens so I look in the
right place in the code.

> BTW, I don't this the table properties modify display format is
> working right, either.

In what way?

Ciao, Neil

[Author]

Posts