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