Subject | Re: Trigger variable in function parameter |
---|---|
Author | jasajona |
Post date | 2006-05-19T11:29:32Z |
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
--------
select
field1
from
table1
into
my_variable;
--------
select
field1
from
table1
into
:my_variable;
--------
Are they identical? If they are identical this can be very confusing
for learning triggers. In manual I found that variable should be with ":".
<m.tonies@...> wrote:
> When using variables/parameters in SQL statements, always include theAre there any difference between these selects:
> ":", in other statements, don't use them.
--------
select
field1
from
table1
into
my_variable;
--------
select
field1
from
table1
into
:my_variable;
--------
Are they identical? If they are identical this can be very confusing
for learning triggers. In manual I found that variable should be with ":".
> probably because you have a column named "v".That is true, my fault :)