Designer DBfields selector

rbuser

Hi,
just a strange behaviour :
RB7.03 std, WIN2K, D7Ent Upd1
I normally develop my reports with associated dataset opened.
If at design time i edit dataset.Sql property the dataset automatically
closes.
When i reopen the dataset, i see all fields duplicated in RBDesigner
fields dropdown.
Best regards
Gianantonio

nicocizik

Hi Gianantonio,

I am unable to recreate this behavior on my machine. Here are the steps I
am taking...

1. Place a TQuery, TDataSource, TppDBPipeline, and TppReport on a form and
link them.

2. Add a simple SQL statement to the TQuery.SQL field and set the
TQuery.Active property to True.

3. View the report and verify the datapipeline fields.

4. Change the TQuery.SQL value to another SQL statement, then set the
TQuery.Active to True again.

This did not seem to duplicate the fields in the DBPipeline.

--

rbuser

Hi Nico,
Yes: it is exactly what i do, but i still see duplicated fields.
The only difference is the TQuery component (i'm using SQLDirect 3.1.2
components) so i have TSDQuery...
But it is a 100% Delphi TDataset descendant and i think it couldn't be
the source of the problem.
My SQL statement isn't complex - a big query with many joins, but
nothing more...
BTW i saw the notification of the "build 2 update", yesterday. I will
install it and let you know.
best regards
Gianantonio

nicocizik

Hi Gianantonio,

As a test, create a small example that just uses TQuery components rather
than the TSDQuery components and see if you can recreate the issue. If so,
please send the example in .zip format to support@digital-metaphors.com and
I'll take a look at it for you.

--