Okay Martijn, thx for quick answer!

Henrik

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 3. februar 2004 18:42
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] sql, variables and Database Workbench

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





Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/