Modifying QBE SQL

[DaveH]

At what point would it be possible to adjust a QBE-generated SQL.

Perhaps in "BeforeQBE"?

What I want to do is to let QBE do its thing, and then add additional criteria after the SQL is generated. Is this
possible? And if so Where? What Event?

Dave

 

[Marco Kalter]

I'm afraid there is no TOracleDataSet event that will allow you to modify the QBE query.

The only workaround is to use the BeforeQuery event of the InternalQuery of the TOracleDataSet. Note that InternalQuery is a protected function, so you will have to derive your own (dummy) TOracleDataSet descendant to accomplish this.

------------------
Marco Kalter
Allround Automations