Use the SQLWhereChanged property. It's job is to let you know prior to
opening the query if any search criteria has been applied during the
OnPrepareSQL phase.

Jason Wharton

-----Original Message-----
From: Christian Gütter [mailto:news@...]
Sent: Wednesday, June 30, 2004 8:02 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] Empty Search Criteria


Hi,

I have a little problem with the search mode.
I start most of my forms with search mode turned on,
because some of my tables are quite huge.

The problem is that when the user enters no search
criteria and posts the search, all records are fetched
from the server. I would like to forbid this, but I
have no idea how to do it.

Any hints are appreciated.


TIA,

Christian