Can?t get the field?s values 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.
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.
This discussion has been closed.
Comments
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