Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

Field Values are not available when I use a manuel SQL

edited April 2006 in Datapipelines
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

Comments

  • edited April 2006

    - 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.



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2006
    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


  • edited July 2006
    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.