nardmoseley
Comments
-
If the DataDictionary does not work at design-time then try to determine
what is different. Perhaps the ASTA connection is not working at
design-time.
Use the TppDesigner.DataSettings to configure the data access that wi… -
Make sure you have configured the DataDictionary.BuilderSettings to connect
to the database.
Here is a tech tip on how to run the DataDictionaryBuilder at run-time so
that you can use the Delphi debugger to determine wha… -
This is not a known issue. The DADE plug-in, when recompiled for RB 10.09,
should work the same as did prior versions.
Check your Designer | DataSettings to make sure they are correctly
configured.
Try a run-time te… -
What RB version were you using before? What Delphi version are you using?
Most likely you just need to recompile it.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
Try updating to RB 10.09, I think that will correct the issue.
If you did not receive download notification about RB 10.09, send your
serial number and registration information to info@digital-metaphors.com and
request i… -
There is a new RB 11.01 build on the server that includes a fix for the SQL
Editor and RAP Code Editor.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
Try downloading RB 11.01 and retest. In my testing here, no error occurs.
Still needs to be researched, will post a follow up here later.
This appears to be a behavior of Delphi TADOQuery. I created the … -
I researched this and the DADE plug-in for ADO needs a small mod. Try
modifying daADO.pas, the method TdaADOSession.ValidDatabaseTypes contains a
single line.
change...
Result := [dtMSAccess, dtMSSQLSe… -
> Hi , sometimes when I design tables save ,exit then reopen report my
This is not a known issue.
What Delphi version, RB version (check the Help | About)?
You might try testing in a simple application with… -
I downloaded the Zeos packages and the daZeosLib7 package and with some
minor mods was able to build them.
1. To build the Zeos packages modify the ZComponentDesign.dpk Requires
clause to include ZComponent.
<… -
1. Try using the Report.CacheManager.CacheType poperty to specify file based
caching. This affects the report engine.
uses
ppTypes;
myReport.CacheManager.CacheType := ppctFile;
2. Check the Report.… -
RB 11 includes some powerful DADE enhancements - including Linking
enhancements. You can link on calc fields and you can edit the SQL and link.
And there are 3 types of linking that are supported. More details here
Try updating to RB 11.03 and retest.
RB 11.03 includes fixes to support multi-value search parameters such as
Between and InList. When you define the Parameter, use the
AutoSearchSettings to specify the SearchOperator as…This is being researched.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
The SQL will be regenerated prior to the report generating.
That Where clause condition is used internally by RB to validate the SQL
against the database engine without selecting any records. Not sure why it
is being sav…
There is now an RB 11.04 patch available to address the linking issues.
Registered RB 11.04 customers can email support@digital-metaphors.com and
request the patch.
--
Nard Moseley
Digital Metaphors
Sorry, I did not see your follow up post to the prior thread.
The Linking issue is being researched and I will post a follow up here.
From RAP you can use TdaSQLBuilder to modify the SQL associated with a
QueryDataView. S…
With RB 11, you can simply type expressions into the Function box.
--
Nard Moseley
Dig…I researched this further.
If you try Delphi code, it will work. The RAP code results in an AV due to a
bug. I have created a patch for RB 11.07 that fixes the issue. Registered RB
11.07 users can email support@ and request th…Thanks for providing more details.
Try something like this
var
lCalcField: TdaCalculation;
begin
lCalcField := SQBuilder.AddExpression('some expression');
// assign the Alias propertyI don't understand the question. What are you trying to accomplish?
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
The name of the Advantage package you have installed will vary by Delphi
version and Advantage version. Use Windows explorer to browse to your
Advantage installation folder and determine the name of the package.
As an ex…Just wanted to post a follow up here, this issue has been resolved.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
I created a patch for RB 12.01 that you can try. I emailed it to you.
The size of your database, 50 GB, is not relevant unless you are doing a SQL
Select on every row in the table. I recommend optimizing the database withRB 11 introduced enhancements to Parameters and SQL that make this possible.
From the Design workspace you can create Report.Parameters[ ] items that can
have AutoSearchSettings. The Parameters can be bound to query search
conditio…You can manually edit the SQL to specify that SQL text.
What issue are you encountering? What is the environment: Delphi version,
ReportBuilder version, database engine, data access components, etc.
--
Nard Moseley<…
MagicSQL is the default linking type.
If a QueryDataView has manually edited SQL text or is linked to a master
QueryDataView with manually edited SQL text, then MagicSQL is not available
and the default linking type is P…
Creating new DADE plug-ins is not difficult. All of the DADE plug-ins are
very similar, I recommend picking an existing DADE plug-in as a starting
point. You can either use one of the plug-ins included with RB, such as
daADO.…
The RB Data workspace (DADE) currently supports parameterized query linking
for the SQL where clause. So that will not work for a stored proc call.
You might consider creating a custom dataview template. For an examples …
I made the same mods here so that AutoSearchCriteriaByName or
AutoSearchFieldByName will check for the FieldAlias or FieldName. That will
be included going forward.
-
Nard Moseley
Digital Metaphors
www.dig…