Dade - enter plain sql?
Hi,
In the past we have always used Reportbuilder with pipelines and queries in
our source code.
I am trying out the dade possibilities as i see many advantages using that
instead.
One thing that troubles me a bit is the query wizard and i'm wondering if
there is a way that i can put my sql in by just entering the plain sql.
On the query wizard the Sql tabsheet is readonly, is there a way i can just
put my own sql in and not use the wizard?
Franky
--
E-mail:franky.brandt@skynet.be
admin@delphiwizard.org
Website: http://www.delphiwizard.org
In the past we have always used Reportbuilder with pipelines and queries in
our source code.
I am trying out the dade possibilities as i see many advantages using that
instead.
One thing that troubles me a bit is the query wizard and i'm wondering if
there is a way that i can put my sql in by just entering the plain sql.
On the query wizard the Sql tabsheet is readonly, is there a way i can just
put my own sql in and not use the wizard?
Franky
--
E-mail:franky.brandt@skynet.be
admin@delphiwizard.org
Website: http://www.delphiwizard.org
This discussion has been closed.
Comments
At design time from the SQL tabsheet, you can right click and select to edit
the SQL if you would like. At run time you will need to be sure the
TppDesigner.DataSettings.AllowEditSQL property is set to True. Note that
once you edit the SQL code manually, you will loose all ability to link your
datasets in DADE.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I didn't spot the rightclick there
Franky
--
E-mail:franky.brandt@skynet.be
admin@delphiwizard.org
Website: http://www.delphiwizard.org