nardmoseley
Comments
-
We are not aware of any updates.
Most of the plug-ins are almost identical. You can compare to one of the
update to date plug-ins and update the daDiamond accordingly.
Try comparing the existing version to one of the… -
The table and field information will be loaded from the dataset to an
in-memory cache, the first time it is needed. Thereafter the cache will be
used - so it should be fast.
To modify the source, you probably want to check… -
Check out daQueryDataView.pas. The method TdaQueryDataView.CreateField
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.c… -
1. The DataDictionary is optimized. However there will be initial overhead
to open the datapipelines and to load the entries into the meta data cache.
From tracing the code, it looks like the call to ReportExplorer.Execute
There has to be a collation order that is applied by the database engine.
Without a comparison function the only option would be to look thru the
entire dataset - which is very slow and would require a much bigger change.
…
Please let me know what you find and I can make the necessary modifications
to the RB source code. We can add code that detects the OS and performs the
appropriate logic.
CompareLinkData is part of the code that needs to b…
The key to solving this issue is to determine the collation order for the
GUID datatype. I searched Google but have not found anything. I will
continue to research it.
Thus far the only information I can find was a newgrou…
The datapipeline linking traversal logic requires the the detail data be
sorted on the linking datafields. The database engine sorts the data, but
what is the collation order that it uses? RB would have to know this. You
have to…
You need to compile the plug-in into a package that is designated as runtime
and designtime. Copy the .bpl to Windows\System (or System32 if applicable).
Install the package into the Delphi IDE. This will register a session type
I just wrote the following tech tip......
----------------------------------------------------------------------------
------
Tech Tip: Implementing a Custom Data Designer
--------------------------------------------…
The architecture was not designed to support this. You would need to search
thru the source code for TdaDataViewToolWin and go from there.
--
Nard Moseley
Digital Metaphors
in using a custom TdaDataViewToolWin Comment by nardmoseley November 2003
1. Windows UI is message based. There are hundreds of messages being sent to
active windows and dispatch to their child controls. Using ShowMessage
causes the the message dialog window to become activated, which interupts
the me…
We do not have any experience with creating BDE Aliases dynamically.
The ReportBuilder DADE Plug-in for the BDE is located in
RBuilder\Source\daDBBDE.pas. The method TdaBDESession.GetDatabaseNames calls
TSession.GetAliasNa…
There is no built-in support to DADE for either of these.
You can modify the DADE Plug-in you are using to support Views, by
overriding the Session.GetTableNames method. For example, if you are using
ADO connectivity, open…
This can be achieved, though it was not designed with that purpose in mind.
Here is an example:
The QueryDataView's TdaSQL object contains all of the search critieria
(whether autosearch or not).
The following example shows to extract the TdaSQL object from a DataView and
add/modify its search criteria.
-------------------------------------------------
Tech Tip: Convert BDE Template Dataviews To ADO
-------------------------------------------------
Currently when DADE is used to create dataviews, the DatabaseName is store…
You can e-mail support@digital-metaphors.com and we can help you with any
questions.
Sounds like you are on the right track. Creating DADE plug-ins is usually a
straight forward process. Best approach is to use an existing…
You will need to iterate thru the subreports and reconnect them to the
appropriate datapipeline.
You can use the Report.GetSubreports method to obtain a list of all
childreport objects. (see the RBuilder.hlp for a method d…
Was hoping there was an RB developer that would step forward with an
example.
Digital Metaphors does not have an example for using ASTA in an end-user
application.
The first step to creating an example would be …
Can you download a trial version of RB 7 and perform the same test. This may
be an issue with RB 6 that has been fixed.
I created a an outer join on customer / orders. I then view the SQL and the
MagicSQL and see that they…
Please create an example using RB and DBDemos data. Let me know under what
version it worked and what version you are using now. I can try it here....
--
Nard Moseley
Digital Metaphors
in SQL Generation Problem Comment by nardmoseley December 2003
There are limitations when you link dataviews, particulary if you sort the
master data.
You may want to take another approach and build the queries using DADE, but
programmatically write the code to link them. This will av…
I this query linked to a master query?
When a detail query is linked to a master, RB generates special linking SQL.
To view the linking SQL, position the mouse over the dataview tool window
and press Ctrl + left mouse. To …
1. First check out the DADE thread of the Tech Tips newsgroup.
2. Here are a couple of examples that might be helpful
ht…
This example using BDE, but should be adaptable to other data access
components:
http://www.digital-metaphors.com/tips/CreateD…
You need to add a connection component to your Dephi form, configure the
connection component to connect to a specfic database, and then set the
Designer DataSettings to reference the connection component. For BDESession
you use…
Try tracing the code in RBuilder\Source\daDBExpress.pas for the method
TdaSQLSession.GetTableNames. You can do this by modifying your Dephi library
path from RBuilder\Lib to RBuilder\Source.
The daDBExpress.pas unit contai…
-------------------------------------------
Tech Tip: Database Collation and Linking
-------------------------------------------
Overview
---------
Linking DataViews in the ReportBuilder Data workspace (DAD…
The QueryDataView.SQLChanged method is the place where the generated SQL
text is assigned to the TDataSet descendant. For an example see daADO.pas,
the TADOQueryDataView.SQLChanged method.
--
Nard Moseley
D…