QBE portion of query text needed

[jedaworks]

I am using QBE on serveral of my forms, and need to know what part of the query is created by QBE. I need to pass the QBE portion of the query to a report module that runs selects records based on what was selected by the QBE query. I cannot pass in the complete query.

Is there some easy way to extract the portion of the query created by the QBE mode?

 

[Marco Kalter]

There is no easy way, but this is how it works. If your original query is something like this:

select
from

where
order by

Then the QBE conditions will be added like this:

select
from

where ( )
and
( )
order by

Knowing this, you may be able to extract the qbe_conditions from the SQL Text.

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