Please use PLAIN TEXT and not HTML for Interbase emailing lists and
newsgroups.

> -----Original Message-----
> From: Marcos Fabiano Mendes de Siqueira
> [mailto:marcosf@...]
> Sent: Lunes 30 de Octubre de 2000 12:47
>
> I am run the procedure below and Interbase show me this message :
> "Statement failed, SQLCODE = -104
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 4, char -1
> -END"

This list is ONLY for conversions from your rdbms X to Interbase. A general
support list exists at Mers.com, available both as a newsgroup and as an
emailing list, whatever you prefer. Only for this time, I will answer here:
Download the ZIP that contains the Interbase 6 documentation and read
Operations Guide and Language Reference. It isn't included in the ZIP that
carries the IB server. You need something like this:

set term ^;
CREATE PROCEDURE Procedure1 AS
BEGIN
select * from table;
END ^
set term ;^

However, this is nonsense and the engine won't allow it. You must get the
result of such select in variables with the FOR/INTO instruction. I don't
intend to repeat here what the manuals say.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com