Hi,
>From the Interbase (2007) Language reference manual ...... "The stored procedure and trigger language does not include many of the statement types available in DSQL or gpre. The following statement types are not supported in triggers or stored procedures: . Data definition language statements: CREATE, ALTER, DROP, DECLARE EXTERNAL..." etc etc So I'd say you can't do it from within a Stored procedure. You might have to do it via DSQL from your code. Firebird would let you do something along the lines of.... DECLARE VARIABLE SQLSTR VARCHAR(2000); BEGIN SQLStr = 'Create Table DAR_RESULTS (PATIENTID char(7), TEST_NAME varchar(30), WHENRECEIVED date, RESULT varchar(16));'; EXECUTE STATEMENT SQLStr; END But I take it you're not using Firebird..... From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Jeremy Coulter Sent: Wednesday, 22 September 2010 9:32 a.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] Interbase Stored Proc 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
_______________________________________________ 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
