Home RAP

SQL Error

edited June 2012 in RAP
Hi,

I have just upgraded to Report Builder 14.05 from 10.04.
I'm attempting to modify a custom SQL statement and get a missing
expression error. This used to work in the previous version. Now i'm
unable to edit any of the sql statements.

I'm using Delphi 7, Report Builder 14.05, Devart (formerly ODAC) and
connecting to Oracle.


Thanks

Alex

Comments

  • edited June 2012
    Hi Alex,

    You posted in the RAP newsgroup. Are you using RAP to edit your SQL
    statement?

    Where and at what time do you receive the error? Do the saved reports
    work before you edit the custom SQL?

    Best Regards,

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

    Yes, I am using RAP to edit the SQL statements. The reports work fine.
    It's only when i try to edit the sql that i get the error.

    Cheers

    Alex

  • edited June 2012
    Hi Alex,

    Thanks for the clarification. How are you editing the SQL? Are you
    accessing the SQL object or using TdaSQLBuilder object? What changes
    are you making? Does any change (even a trivial simple change) cause an
    error?

    If you are not using the TdaSQLBuilder object to edit your query, I
    highly recommend that you do. It offers an easy to use wrapper for the
    TdaSQL object (and gives access to the SQL object in case you need it).

    See TdaSQLBuilder in the RB help.

    Best Regards,

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