Verification

rbuser

When ever we create a new query it seems to take forever to create. We
have looked at the database to see what is occuring and noticed WHERE ('c'
<> 'c') appended to the SQL to help in the verification process.

Now this is no issue when there is 100's of results to a query but we
typically will have 1000's to 10,000's or records and the speed is driving
our clients nut.

In our old heavily customised RB6 we changed the verification to build a
temporary view to speed this process up. (We use Oracle)
Now my question are,

Is there a way that we can change the verification method of the SQL
generated within the Data tab?

Is it possible to override the standard verification with our own?

Or (not my preferred method) do we have to hack the source code again?

Is this a feature we could request if it does not exist?

Regards
Charles

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Charles,

There is no automatic way to override how ReportBuilder gathers the field
information however we created the DADE plugin architecture so that you can
take control by altering them as you need (or by creating a completely new
one). Depending on which plugin you are using, take a look at the
TdaDataset.SetDataName to see where we are gettig the field info. This
routine can be easily altered to meet your needs.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

I actually did not mean how the field information was gathered although
this information I might be able to use later. What I actually mean't was
the WHERE ('c' <> 'c') that is appended in the following areas
TdaSQL.BuildWhereClause and TdaSQL.UpdateCalcSearchCriteriaDataTypes.

I was wondering if it is possible to override these areas at all?


Regards
Charles

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Charles,

Unfortunately there is no automatic way to alter the way these routines
access data. Thank you for the feedback, we will consider enhancing this
for a later release of ReportBuilder.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com