Where Clause Generated with QBE

[BlueNitro]

Hi,

When I use the TOracleNavigator to run a QBE. How do I get the where clause that it generated to retrieve the data?

Thanks!

 

[Marco Kalter]

After executing the QBE query, the SQL property of the dataset contains the modified SQL, including the where clause.

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

 

[BlueNitro]

Thanks, but I've already found that out.

I was just wondering if there was a way to get just the new sql that was added.

Also, it creates variables like :doa__qbe7, :doa__qbe8. Does it always start at 7 and increment from there? Why does it start at 7?

Thanks

 

[Marco Kalter]

There is no functionality to obtain the SQL that was added. Your application would have to compare the original SQL and the QBE SQL.

The variable name :doa_qbe7 indicates that this is a QBE variable for the 7th dataset field.

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