[DUG] Interbase Stored Proc

[Jeremy Coulter]

Hi all.
I know a few of you out there work with Interbase so I thought I might ask
the following question here.

I want to create a stored procedure that creates a table. So I am doing :-


CREATE PROCEDURE MySP_ AS
begin
 create table DAR_RESULTS
(
PATIENTID    char(7),
TEST_NAME    varchar(30),
WHENRECEIVED date,
RESULT       varchar(16)
);
END


However, it doesnt like this and complains avout the "("  althought when I
removed this it still gave the same error :-)

can someone who knows IB a bit better point me in the right direction?


Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100922/9162c731/attachment.html