Hi Henrik,

> 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?

You SHOULD use the colon. This is a bug in Database Workbench.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com