Subject sql, variables and Database Workbench
Author Henrik Sitter
Hi, I have a stored procedure where I ask:

if (exists(select 1 from aTable where Col1 = :aVar)) then
begin
.
.
end

aVar is a variable declared in the stored procedure. When I "compile"
the procedure I get a warning:

"Usage of ':' not recommended outside an SQL statement"

First of all, this is a SQL statement (isn't it...)? Second, what should
I use instead? If a drop the ':' I get the following error:

"ISC ERROR MESSAGE......Column unknown"

The procedure works as expected (it seems), so I believe this warning to
not being harmful, but it would be nice to get rid of these warnings.

Henrik