DADE Linking

rbuser

Hi

RB12.03 Ent & Advantage

I recently amended a report that was originally written in RB9 (i think).
There are multiple data sets (one for each year showing monthly sales)
linking back to a table containing the list of months. I then had a report
showing cumulative monthly sales for each year using DBCalc fields. The
problem came with the figures for 2011 which rather than the cumulative
figure being Jan + Feb it was Jan * 2. I eventually tracked down the
problem to the use of Parameterized Sql rather than Magic Sql (sql tab in
the Link tab). The problem was that i could not change the setting to Magic
Sql. Eventually by deleting the dataview and starting again i was able to
change it and all then worked as required.

I can see the reason for the Parameterized sql option but i have various
questions: What should the default be? Can it be changed? Why had the
Magic sql become unavailable? Should there be an edit facility if Manual
sql is chosen?

There does not appear to be any guidance on this in either rbWiki or the
help file so if anyone can give a bit of input i would be grateful.

Thanks

Tim Murfitt

nardmoseley

MagicSQL is the default linking type.

If a QueryDataView has manually edited SQL text or is linked to a master
QueryDataView with manually edited SQL text, then MagicSQL is not available
and the default linking type is Parameterized SQL.

There are one or two other exceptions. MagicSQL only works when linking on
fields in the first selected table of a join. And I think linking
calculated fields is also not supported by MagicSQL.

The linking types were added for RB 11. Prior versions did not support
linking for manually edited SQL.

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_11/DADE


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com