nardmoseley
Comments
-
When DADE dataviews are linked, there is special linking SQL that is
generated for the detail dataset. Perhaps the newer firebird database engine
is having an issue with the linking SQL. See the following article for more
detail… -
We have an updated DADE plug-in for DBISAM available from
support@digital-metaphors.com - it has been tested using RB 7.04 and DBISAM
4. Interested customers can email support@digital-metaphors.com and request
it.Rick,
You will need to update and recompile the DADE plug-in for DBISAM. The
rbISAM.dpk package needs to have its requires clause updated to use the
latest DBISAM packages.Then recompile the package. Copy the .bpl to
Window…
I do not understand. In my example, Orders are linked to Customer. The
linking field is CustNo - which is a unique identifier or key for the rows
of the master query. This is required. It is possible to define a link on
multiple…
I performed a simple test using the DBDemos database. I created a master
query that selects all customer records. I created two detail queries on
orders. I linked the detail queries to the same master. I added search
criteria to…
Glad to hear the issue is resolved.
--
Nard Moseley
Digital Metaphors Corporation
www.digital…
The Designer.DataSettings are used to create new queries. Once a query is
created, the DataSettings are saved as part of the query definition. You may
have created some reports that contain querys that do not reference a valid
c…
1. To link in the ReportBuilder DADE plug-in for ADO, you need to include
daADO in the uses clause of the application.
2. Delphi enables applications to be compiled by linking all .dcu's into a
single .exe or by dynamicall…
ReportBuilder's support for BDE Local SQL works correctly. Local SQL refers
to the Borland Paradox engine. No ODBC is used. Try using the Standard
driver.
A better solution for DBase files is to use the Advantage databas…Jacques,
Thanks for the clarification and for sharing your knownledge on this. We
will incorporate your recommended modification into the next release.in TdaSQL Error when quoting Reserved word for MySQL Comment by nardmoseley September 2004
Thanks for the information. Will using a single quote work for all mySQL
servers or is this configurable? Or perhaps it varies by version? Please
clarify.in TdaSQL Error when quoting Reserved word for MySQL Comment by nardmoseley September 2004
The current limitions are
- You cannot specify a function as a search value
- You cannot specify a calculated field as a search value
1. To search against a field value, specify tablename.fieldname as the
se…
This a tough question, partially because I do not know what type of changes
you have made.
A good place to start would be the DADE plug-in that are using. I am
guessing that you using the BDE plug-in, which is defined in d…
Try using a the SQL Cast function to convert to the type that you need.
This more of a database to TDataSet type of operation. RB is leveraging
Delphi to get the field info. RB uses the TDataSet component (for BDE, it
uses…
The TdaSQL object can be used to construct most types of search conditions,
it in no way limited to use Like as the search operator. You can use the
TdaSQL object to define the types of SQL that the Query tools support. Try
usin…
Sorry, I do not understand the question.
What is wrong with the solution that we provided? You asked how to build and
link queries and we provided a solution. You then asked how to apply search
criteria and we modified the…
I updated the example to include autosearch criteria on CompanyName. Try
downloading again.
I also found an error. For each dataview the SQL.DataBaseType and SQLType
property values were incorrect.
--
For an overview of the DataView architecture, please see the DADE thread of
the Tech Tips newsgroup. Beyond that we have the demos which contain
commented code. For the next release we are adding improved support for
dynamically…
There are two options:
1. You can write code to extract the TdaSQL object from the DataView and
modify it.
www.digital-metaphors.com/tips/ExtractSQLObject.zip
The next release will contain a simpler runtim…
You can try doing that. I do not know how safe it is, I cannot think of any
issues off the top of my head. To copy the pipeline fields, try creating a
pipeline and then loop thru the original pipeline fields and change the
DataP…
I don't know of any way around that. The underlying field name (the SQL
alias) is changing and that is causing different fieldnames to be created.
The FieldAlias displayed in the designer always maps to the fieldname and
the DBT…
For future reference, questions about using the Calc workspace should be
posted to the RAP newsgroupt. (questions about using the Data workspace can
be posted to the DADE newsgroup. )
The functions found in the CodeToolbox…
Not sure I understand the question.
1. Are you trying to use the Query Designer's Calc tab to create a
calculated field for the query that has formatting. If so then you need to
use whatever functions your sql server produ…
I did not fully understand the original question. So you have an AutoSearch
value and you want to use the value to build a query against the database
that is used to populate search criteria for other queries in the report.
Below is an example that you can download. For the first query, create
autosearch criteria and then for the subsequent queries create standard
search criteria. When the user enters the search criteria, you can
programmatically a…RB 7.04 includes some improvements for supporting Largeint datatypes. Try
updating to RB 7.04 and perform the same test. If you still have an issue,
then create a simple example that we can run here. We have Advantage
installed here, …
ReportBuilder does not affect the BDE at all. There are no known issues
with ReportBuilder and the BDE.
Perhaps you made some other changes to your system.
Try quitting out and rebooting your system. If that does not…
-------------------------------------------------
Tech Tip: How to modify the DatabaseName stored
with a DADE Query
-------------------------------------------------
Currently when DADE is used to create dat…
1. Once you create a dataview, the columns for that dataview are
persistently defined and stored. The SQL generated for the dataview,
likewise lists the columns explicity - it does not use Select * notatation.
2. The Query…
I don't understand what you mean when you say that you updated the tables
structure. Do you mean that you run the end-user application and create new
folders and reports?
If you are compiling the plug-in into a package, th…