>On Freitag, 23. November 2007, hartertobak wrote:
>> if (:SEARCHEXISTS = 0) THEN
>
>if (:searchexists is null)

This will work, because if you do not initialize your variables,
they will contain NULL.

Take in account, that if no rows are found, the variable will
contain the same value as before the SELECT ... INTO.

As a "rule of thumb", it might be wise to get used to initializing
your variables yourself.

>or with FB 2.0
>
>if (row_count=0)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com