use FOR instead of table
Edward Koryagin
--- On Wed, 22/9/10, Jeremy Coulter <jscoul...@gmail.com> wrote:
From: Jeremy Coulter <jscoul...@gmail.com>
Subject: [DUG] Interbase Stored Proc
To: "NZ Borland Developers Group - Delphi List" <delphi@delphi.org.nz>
Received: Wednesday, 22 September, 2010, 9:32 AM
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
-----Inline Attachment Follows-----
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject:
unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject:
unsubscribe
