Subject Re: Master Detail Problem
Author rhowitt
I did some futher investigating.... I came up with a very simple
program that had 1 master and 1 detail TwwiboQuery .
The master data has 4 columns that the detail will use in a
parameterized query. One of the columns in the master may contain ''
(blank) data, but never null.

When I compile and run the program in Delphi 2005, the detail data is
found correctly. When I run the program in Delphi 2007 the program
does not find the detail rows that have blanks in the Master.

Is there a setting I'm missing or what?

Thanks in advance

Rick Howitt




--- In IBObjects@yahoogroups.com, "rhowitt" <rhowitt@...> wrote:
>
> I have an application that I am upgrading from Delphi 2005 to Delphi
> 2007. It recompiled without any problem.
>
> I am using IBO 4.x with TwwIBOQuerys.
>
> I have a Master dataset with persistant data fields and a Detail
> dataset with persistant fields, the detail is linked to the master via
> the DataSource property. The Detail has 5 parameters that are to be
> filled in by the Master.
>
> Neither Query is linked to a another object except for the DataSource
> that links the master detail relationship.
>
> The code has a "while not Master.eof do" loop that runs through the
> Master records. The problem is that the parameteres in the detail are
> not filling in and therefore no data is being returned for the detail.
>
> In debug mode, as I iterate through the loop, all params are blank,
> although every now and then one of the params has the correct value
> from the master. The rest are blank.
>
> I've checked the spelling to make sure the detail params match the
> fields in the master. I've set the parameter type(String, integer,
> etc) for each parameter.
>
> This same code works fine in Delphi 2005.
>
> Any suggestions?
>