[DUG] Interbase Stored Proc

[Willie Juson]

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-bounces at delphi.org.nz [mailto:delphi-bounces at 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

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