Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Cannot Edit SQL - D6 RB10.04

rbuserrbuser
edited September 2006 in General
Hi

I have set AllowEditSQL to TRUE but I still cannot edit the SQL.

I am using ODAC as my driver, does that have any bearing on this?

I need to edit some SQL as a previous version of my reporting tool placed
the schema name in front of the table/view I now need to remove this.

regards

Comments

  • nicociziknicocizik
    edited September 2006
    Hi Andrew,

    If you click on the SQL tab of the query designer, you can then right click
    over the greyed out SQL code and select the "edit" option. You will be
    given a warning and then be given the editable SQL text.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited September 2006
    Hi

    It is obvious now. Just saw the grey and assumed it was not editable.

    Probably this question is in the top 10 of FAQ's

    Thanks



This discussion has been closed.