RB9 SQLBuilder

rbuser

Hi DM Team,



I downloaded the new leaning apps from your website last friday to find out
what's new.

Did a quick search in the pdf's on anchor, pdf, mailmerge and sqlbuilder but
didn't find a single hit. ???

I am particular interested in the SQLBuilder class and what and how you can
use it from RAP.

Is it for example possible to make a OnDrawCommandClick() event that changes
the sort order of the query on the fly?



I also must say that I found the upgrade price pretty high compared to your
previous upgrade prices. BUT on the other hand: If I compare the support
supplied by DM with other tool suppliers it's worth it. Almost every
(99.99%) question in these newsgroups is useful answered by DM (Nico great
job!!). Even if the question is asked a dozen times.



Regards,

Jeroen Rottink

nicocizik

Hi Jeroen,

Thanks, I appreciate your comments.

The SQLBuilder was created to give developers an easier way to use the
TdaSQL object in code. If you have ever looked at the TdaSQL source, you
can easily see why this was needed. There was virtually no documentation
and most of the underlying concepts were very difficult to understand. The
TdaSQLBuilder provides a set of routines simplifying the process of using
the TdaSQL object in code (as DADE does). It is also extensively documented
including examples to simplify things even further.

To answer your question, the SQLBuilder was not designed to be used during
or after report generation. This is why new events were added to RAP so you
could successfully set up your data before the report started generating. I
cannot guarantee what you want to do is possible, I would suggest trying it
in regular Delphi code first then trying to move it to RAP.

--