> I Have a problem using the Lookup method of TIBOQuery.
> The problem is that if the Value to lookup doesn't exist
> in the dataset, an SQL statement is prepared and the Dataset
> tries to fetch the Value from the Database.
> I don't want this to happen, since i only want to know if
> the Value exists within the current Dataset.

> Is there anyway to prevent this from happening ?

Not sure I understand the question. It is possible to do an
EXISTS test inside a stored procedure, so you could write a
procedure and call that. But one way or another you will have
to prepare an execute some sort of statement against the
server to discover whether a record exists. How else do we
know if the row exists unless we ask the server?

Somehow I think I may have missed the point of the question :-(

--
Geoff Worboys
Telesis Computing