Params with TdaSQL

rbuser

Hello,

I have this sample of SQL query :

SELECT * FROM CUSTOMER
WHERE BirthDate < :"BithDate"

My question is : how to access the param "Bithdate" to affect value or to
set the datatype ????

Thanks for help !

nardmoseley

----------------------------------------------
Tech Tip: Limitations of using TdaSQL.SQLText
----------------------------------------------

The TdaSQL object can contain either an object based description of the SQL
(SelectTables[], SelectFields[], etc.) that it uses to generate SQLText OR
it contain a SQLText string. If you specify the SQLText string then TdaSQL
will not generate any SQLText. Therefore the built-in AutoSearch and Linking
features can no longer be used - because these require that special SQLText
be generated.

If you want to use AutoSearch with a SQLText, you will need to handle this
in your custom dataview code. For an example see RBuilder\Demos\AutoSearch
and see the TdaQueryDataView.CreateAutoSearchFields and
TdaQueryDataView.ReportGetAutoSearchValuesEvent methods in
daQueryDataView.pas.

You can also check out

www.digital-metaphors.com/tips/ExtractSQLObject.zip




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