digitalmetaphors
Comments
-
The only way the meta data cache could be corrupt is if the datasettings
change after the meta data cache has been populated. It sounds as if there
is a problem wher eit thinks that it has generated the meta data cache, but
hasn't ful… -
Yes, it should be clear when you change the datasettings at Delphi design
time and build the project. The dataviews that are in your report should be
configured to connect to the database that you are trying to connect to at
runtime,… -
After you change the datasettings to point to your database, you need to
call the gMetaData.Clear routine to clear the meta data cache. The meta data
has been populated with the demo's meta data values, so you need to clear it
so that… -
Here is an example that does work to add to the SQL object's WHERE clause.
Test with this way of adding a field to the criteria field and see if that
helps. You shouldn't have to clear the meta data cache with this approach.You need to clear the cache.
----------------------------------------
Tech Tip: Clearing the Meta Data Cache
----------------------------------------
There is a global meta data cache that the ReportBuilder uses to ca…The report is building meta data that it can use, so it gets all of the
table names from the database. When you use the query tools to select a
field, then it retrieves all of the field information and places the field
names in the c…The data dictionary does this because it has to support many databases
vendors. Most don't support a boolean field type. You can see in
TppDataDictionary.CreateFields in ppDsgnDB.pas that the calls to
ppStringFieldValueToBoolean retur…Thankyou for evaluating ReportBuilder 7! You'll can generate additional
entries in the data dictionary to support each table owner name if you want
to control this on a userID level. Our data dictionary end user tables are
not compl…Please start a new thread for each new question. It might get hard to follow
if there is a long discussion:)
The autosearch dialog is customizable. You can replace roughly 99% of the
forms in RB. There is an example of replacin…If you want to add some criteria objects, then you can use the
Report.Template.OnLoadEnd event. It should work also in the
Report.BeforePrint event, because this is the timing that I use regularly
when adding DADE objects. First, ma…You don't have to edit the SQL text. You can define search criteria on the
fly. They can be autosearch or not. Autosearch means that you can specify
search criteria values. If there are no search criteria defined in the
dataviews when…The Report has a datamodule that you can extract to get at the dataview
objects at runtime. From there, you have two options, edit the SQL text or
manipulate the criteria objects in the dataview. The two options differ in
that the f…Have you tried contacting the author of the plugin, Grant
Dunoon?gdd@flagship.com.au He is the person responsible for maintaining the
plugin.
There is no example shipped with ReportBuilder. You should be able to adapt
the s…The good news is that the application works with the data dictionary on your
machine. This means that the data dictionary is configured correctly when
you compile and your data dictionary data is correct. When you distribute
the app…Thankyou for the corrections.
Cheers,
Jim Bennett
Digital Metaphors
The current daAds.pas plugin in RB 7 should get the Advantage data
dictionary table names using the Ads.ini file. Place a breakpoint in
TdaADSSession.GetTableNames to see if it isn't getting inside that code to
get the table names fr…You need to click Generate, not Synchronize. Synchronize should delete any
entries for data that do not exist in the database anymore.
Cheers,
Jim Bennett
Digital Metaphors
What version of ReportBuilder and Advantage are you using?
Can you run our example Advantage end user application? It is located in
your installation in the RBuilder\Demos\EndUserDatabases\Advantage\Native
directory. Use the ex…How are you manipulating the TdaSQL ojbect? Here is an example of
manipulating it, adding search criteria as well:
http://www.digital-metaphors.com/…You'll have to modify the DADE plugin (daADS.pas) to not reference this unit
as the Advantage data dictionary was released in Advantage 6. Remove
AdsDictionary from the uses clause and modify TdaADSSession.GetTableNames to
not use t…Yes, the interface section of the ancestor had to change to support thread
safety for the RB 7 Server Edition. Essentially, the SetDatabaseName
changed to SetDatabase. The standalone utility routines in the unit should
moved to be lo…No, DADE expects a field to be used as the GROUP BY. There is no support for
the expression type group by. If you want to add a GROUP BY in code, then
use:
procedure TForm1.CreateGroupBy;
var
lSQL: TdaSQL;
li…Make sure the database name matches the component name in your database
object on the form. The plugin must not be able to find the database object
on the form if the two string properties aren't the same. I don't have FF2
installed …You can download it here:
http://www.digital-metaphors.com/tips/daASTA.zip
Cheers,
Jim Bennett
Digital Metaphors
You are making calls that are meant to be internal to RB, however, they are
there and you can use them. How about using the demo end user project on
this database. Use our out-of-the-box demo to see if you can reproduce the
problem …Use the RB data dictionary.
Cheers,
Jim Bennett
Digital Metaphors
It is slower because DADE is sending a query to get all the available table
names and field names when you create a dataview. It then stores this
infomation in the meta data cache. Try using the data dictionary component
to define th…It is in the Windows system directory.
Search in the Windows file explorer for rbADO*.bpl
Cheers,
Jim Bennett
Digital Metaphors
At runtime , include daADO in your uses clause. At Delphi design time, you
need to be sure that the rbADO77.bpl is installed as a package in Delphi.
Cheers,
Jim Bennett
Digital Metaphors
That was a mistake on our part and has been fixed for the next release. Copy
the pas file from RBuilder\Demos\RCL to RBuilder\Lib.
Cheers,
Jim Bennett
Digital Metaphors