QBE

[Lasse Koskinen]

Is there any way of knowing that the sql of a dataset has been modified by QBE?

Lasse

 

[Marco Kalter]

There is no formal property that indicates this, but the SQL text contains '/* Modified for QBE */' in this case. I admit it is not very elegant, but it works. We have some enhancements planned for QBE, we will include something for this as well.

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

 

[dtumbov]

Does it means that I have to process the SQL string in order to find out which fields have been populated during the "Enter Query" mode ?

Regards,
Dimce

Originally posted by mkalter:
There is no formal property that indicates this, but the SQL text contains '/* Modified for QBE */' in this case. I admit it is not very elegant, but it works. We have some enhancements planned for QBE, we will include something for this as well.

 

[Marco Kalter]

In the current 3.4 version you can use the TOracleDataSet.QBEModified property to check if any QBE where clause is present.

After the QBE query is executed, you can use TOracleDataSet.QBEDefinition.Fields[FieldIndex].LastValue to determine if any QBE value has been entered.

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