Field Values are not available when I use a manuel SQL

rbuser

Hello!
I?m using Apollo tables with Reportbuilder 9.01.
I change a SQL with the TdaSQL in the InitializeParameters-Event:

...
lDataView:=lDataModule.DataViews[nTab];
aSQL:=TdaSQL.Create(nil);
aSQL.Assign(TdaQueryDataView(lDataView).SQL);
ShowMessage(aSQL.SQLText.Text);
...
TdaQueryDataView(lDataView).SQL := aSQL;
...

It works, but when I want to use the OnCalc-Event the Values of the
Fields like: TABELLE['TEST'] have no Data.

I have to use the manuel SQL, because Apollo can?t execute every SQL of
the SQLBuilder.

Can someone help me?



--- posted by geoForum on http://delphi.newswhat.com

nardmoseley

- Try using the TdaSQLBuilder class instead. This is a new class introduced
in RB 9 that can be used to easily modify the TdaSQL object associated with
a Query DataView. Check out the RBuilder.hlp topic for TdaSQLBuilder.

- The Designer.DataSettings properties for SQLType and DatabaseType can be
used to control the SQL syntax that is generated. What types of syntax
issues are you encountering?

- Are you using a DADE plug-in for Apollo? I checked the Download | DADE
plug-ins section our web site and see a VistaDB plug-in but not an Apollo
plug-in.

rbuser

What if you are using the end-user report designer? I really need to do the
same thing since my results are in a stored procedure, yet I need to supply
search criteria at run-time.

Thanks,

-Max

nardmoseley

RB 10 includes an example of using stored procedures and autosearch fields.
The examples shows how to create custom custom dataview classes that can do
this. It is installed to RBuilder\Demos\EndUser Database\SQL Server\ADO.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com