Subject | IB Question |
---|---|
Author | R. Tulloch |
Post date | 2002-06-11T12:59:36Z |
Hi:
I am using WI-06.0.1.6.
Database dialect 3
In making SP's I have consistently hand to use no colon in for
example:
SELECT COUNT(*) FROM TABLE1
INTO MyVar;
I hve been engaged in an exchange with a fellow who says
that the colon IS required.
SELECT COUNT(*) FROM TABLE1
INTO :MyVar;
We exchanged metadata for sp's which support our respective
positions.
It later came to light that he is using IB 6.5.
There can't possible be such a difference between the IB OE build
from mers
and the IB 6.5 commercial version, can there?
Thanks.
Best regards
I am using WI-06.0.1.6.
Database dialect 3
In making SP's I have consistently hand to use no colon in for
example:
SELECT COUNT(*) FROM TABLE1
INTO MyVar;
I hve been engaged in an exchange with a fellow who says
that the colon IS required.
SELECT COUNT(*) FROM TABLE1
INTO :MyVar;
We exchanged metadata for sp's which support our respective
positions.
It later came to light that he is using IB 6.5.
There can't possible be such a difference between the IB OE build
from mers
and the IB 6.5 commercial version, can there?
Thanks.
Best regards