Parametrized Query and AutoSearch

rbuser

Hello,

I'm using RB 6.03.

I have some reports wich use complex queries (queries that cannot be done
with the integrated wizard). So I edit the sql by hand (the query is in the
report). Is it possible to make "by hand" queries and AutoSearchDialog. For
example, if my query is "Select * from theTable where col = :val", how could
I make it work (the report should ask for :val after I call the print
method). All examples I saw refer to external datasource / pipeline.

Thank you

Jean Lacoste

nicocizik

Jean,

Yes, it is possible to manually show an autosearch criteria with manually
edited sql.. The example below shows how to do this. Notice that the
autosearch values will need to be extracted from the dialog and added into
the changed SQL statement.

http://www.digital-metaphors.com/tips/EditSQLAndSearch.zip

--