[DUG] Interbase Stored Proc

[Edward Koryagin]

use FOR instead of table

Edward Koryagin

--- On Wed, 22/9/10, Jeremy Coulter <jscoulter at gmail.com> wrote:

From: Jeremy Coulter <jscoulter at gmail.com>
Subject: [DUG] Interbase Stored Proc
To: "NZ Borland Developers Group - Delphi List" <delphi at 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 at delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100921/69798d58/attachment.html