SQL sentence.

rbuser

Hi all.

I need to add a critiria of seach directly in the sql sentece.
I don't know the syntax to do it. Please give me a little help.

Fabio.

nicocizik

Hi Fabio,

Take a look at the AutoSearch demos located in the
\RBuilder\Demos\Autosearch\... directory. These will give you a good idea
how to alter the SQL statement where clause at runtime in ReportBuilder.

If you are using DADE, take a look at the new SQLBuilder object included
with RB 9 or later. There is extensive help and examples located under the
TdaSQLBuilder topic in the RBuilder help.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico, but I guess you're talking about delphi sintax code. I mean it
in the reportbuilder code (which is the same), but I've created an end-user
application in which I'm working at. I hope you excuse me if I don't
understand you, but please, let me know so.

Thanks.

Fabio.

nicocizik

Hi Fabio,

Which version of ReportBuilder are you using? If you are using RB 9 or
higher, you can utilize the SQLBuilder object as I mentioned in my previous
post. This object and its features to add, edit, and update your queries in
DADE are available in RAP (ReportBuilder code). There is extensive
documentation and examples located under the TdaSQLBuilder topic in the
RBuilder help.


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com