Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Removing DADE conection ...

edited May 2007 in DADE
Hi all,

How do i remove a DADE connection after it has been created. I tried
removing the SQL but it keeps saying the SQL is missing.

Is there another way to remove it.

Regards,




Trevor

Comments

  • edited May 2007
    Hi Trevor,

    You can use the TdaSQLBuilder (TdaSQLBuilder.Clear routine) to clear out a
    DataView of all tables and search conditions or if you would like to
    completely remove the entire dataview, you can simply free the
    TdaQueryDataView object.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2007
    Hi Nico,

    Is this something i will have to do every time i run the report.

    Or is it something i do once and thats it.

    I have 2 etries in the data tree of the report designer. ChildDBPipeline1
    and DBPipeline

    I want to remove the ChildPipeline1 completely and not have any entries in
    the data tab at all so i can use the data connection on my forms or
    datamodules.

    Regards,



    Trevor




  • edited May 2007
    Hi Trevor,

    You will need to either remove the ChildDBPipeline every time you load that
    specific template or remove the dataview manually and resave the template.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.