SQL Error

rbuser

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

nicocizik

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?

rbuser

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

nicocizik

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.