nicocizik
Comments
-
Hi Chantal,
For future reference, please use your name in the "from" field when
posting to these newsgroups.
In my quick testing with the latest version of ReportBuilder, I was
unable to get a list out of bounds err… -
Hi Andy,
I believe your method will still work, you just need to access the
proper table. Currently you are looking in the INVHEAD table for a
field that does not exist.
lTbl := lQueryDataView.SQL.GetTableForSQLAli… -
Hi Andy,
Which version of ReportBuilder and Delphi are you using? What error are
you receiving? The AddCriteriaField routine is not necessarily designed
to be used in this way. SelectCriteria would be a better option.
… -
Paul,
I'm sorry but I cannot give any time frame on when a new feature will be
added to the product.
We appreciate the feedback and have added your suggestion to our list of
possible enhancements. I can tell you th… -
Hi Paul,
Unfortunately there is no way to alter the table order for the
programmatically created SQL other than doing it by manually editing the SQL
yourself. Looking at the code, it does not look like a trivial addition to <… -
Hi Paul,
Try calling SQL.Valid before making the call to ApplyUpdates. This will
refresh the field lengths before assigning the SQL object.
...
lSQLBuilder.SQL.Valid;
lSQLBuilder.ApplyUpdates;
… -
Hello,
For future reference, please post using your real name when using these
newsgroups.
It appears the link we have on our website is no longer available. I
will have this updated.
I did however find … -
Hi Ben,
Which version of ReportBuilder are you using?
In my testing with the latest version, the following SQL code executed
correctly using the DBDEMOS database.
SELECT orders.OrderNo, orders.CustNo,
… -
Hi Ben,
To access a parameter from SQL code in DADE, you will want to use the
following syntax:
WHERE TerminationDate < :MyParameter
This is identical to the Delphi parameter syntax.
-
Hi Jason,
Thanks for the info.
This will be added for the next release of ReportBuilder. There is also
a patch that adds this for RB 14.08. Registered users of RB 14 can send
an email to support@ to receive the pa… -
Hi Ignacio,
Which version of ReportBuilder are you using? Parameter support for
calculated fields in DADE was added for RB 12.
-
Please send all files to support@digital-metaphors.com.
-
Ignacio,
In my quick testing with a simple application and the DBDemos database,
I was able to insert a parameter value into a calculated field in DADE
and execute the query successfully.
Please provide more informa… -
Hi Ignacio,
For future reference, please continue the existing thread rather than
starting a new one for each response.
If you are calling PrintToDevices you need to be sure to initialize the
parameters before print… -
Hi Diego,
To manipulate the data workspace from RAP, we strongly suggest using the
TdaSQLBuilder class. This is a wrapper class giving easy access to the
DADE SQL class. Using the SQL Builder, you can easily create, alter, <… -
Hi Rolphy,
I was referring to processing the parameter (in Delphi code) before it
is used in your dataset.
For instance, imagine you have a parameter named MyParam which is
defined by your user. If your user does n… -
Hi Rolphy,
ReportBuilder parameters do not support null values so the following
expression will not be evaluated.
{ifnull(:MyField,MyField)}
From what I can gather, the IfNull routine is meant to be used in th… -
Hi Rolphy,
You are correct, when a FireDAC "macro" function is used in a search
condition in DADE, it is recognized as a string. These types of
functions are not currently supported in the WHERE clause using DADE.
We wi… -
Hi Rolphy,
FireDAC "Macro" functions are simply built-in routines that process text
before it is sent to the DB. ReportBuilder does not have any logic to
block this feature.
In my testing FireDAC macro functions wo… -
Hi Ignacio,
You did not mention that you are using RAP
.
For RB 15, we added support for the Values prope… -
Hi Ignacio,
I apologize, I did not know you were using parameters.
You can access the parameter values using the TParameter.ValueCount and
TParameter.Values[] property.
For example:
lParameter := Rep… -
Hi Ignacio,
Use the TppAutoSearchField.Values property to get access to the
soBetween or soInList values.
Access the AutoSearchField object using the Report.AutoSearchFields[]
property or AutoSearchFieldByName routi… -
Hi Jason,
Yes, if you take a look at the daADO.pas file inside the
TdaChildADOQuery.SetConnection routine, you will see that we assign the
CommandTimeOut property from the ADOConnection object.
When a QueryDataView … -
Hi Paul,
ReportBuilder uses threading for background printing, previewing in RB
14 or later, and the Server.
If you are not creating a server, you can disable threading by disabling
Background Printing and setting t… -
Hi Paul,
Interesting, this appears to be an issue that only shows up some of the
time. I was able to reproduce it however.
I created a patch for you to try. Send a short email to
support@digital-metaphors.com to r… -
Hi Paul,
I aplogize, I did not see that you had tried the other linking options.
You are correct that the Magic SQL option in the link dialog should be
disabled for this specific case. We will change this for the nextHi Paul,
Magic SQL linking is not supported when the master contains an aggregate
field (which is why the link dragging does not work in your case).
Try using parameterized or manual linking to get the result you are afte…Hi Julien,
I'm a bit unclear about your requirement. Are you trying to accomplish
these date ranges in RAP code or would you like to initialize the
parameters outside ReportBuilder in Delphi?
If you are using…Hi Phil,
There is a patch available for RB 16.02 that addresses this problem.
Please send a short email to support@digital-metaphors.com requesting
the patch and we'll send it to you as soon as possible.
Hi Ed,
Are you getting a compiler error? What error are you getting when you
add this code?
Are you sure you have the Source directory in your library path so the
updated daDBExpress.pas file is being used?