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

Can?t get the field?s values in Rap

edited March 2005 in RAP
I am doing a showmessage in some fields, i know they have values but
they don?t show.


At the -ppReport1InitializeParameters - event , i identify that if a
comment the command below, the values are showed!

lSQLBuilder.SelectTables.Add('Table1')



But i need this command to be executed ohterwise my sql params did not
work. I made a customization in order to be able to define parameters at the
sql code, and request values for them from the user, and then use this
values to generate the report.

Comments

  • edited March 2005


    What is the goal? Are you trying to replace the name of an existing table or
    add a table join?

    The TdaSQL object and TdaSQLBuilder work very much like the QueryDesigner.
    When you add a table, you need to add fields, etc. If you remove a table,
    the fields will be removed. If you add a second table, you need to specify a
    join condition.

    If you comment out the line and it works, then I assume the TdaSQLObject
    already contains a valid SQL definition.


    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

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