Subject | sql, variables and Database Workbench |
---|---|
Author | Henrik Sitter |
Post date | 2004-02-03T17:33:13Z |
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
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