At 11/06/2002 09:59 AM, you wrote:

> I hve been engaged in an exchange with a fellow who says
> that the colon IS required.
>
> SELECT COUNT(*) FROM TABLE1
> INTO :MyVar;

This is the correct format and it is documented in the IB 6 beta documents
in the Language Reference Guide on page 170(look at the example on page
171). Probably in IB 6.01 Open Edition, it's not checked properly.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)