Subject | Re: [ib-support] Creating Tables Problem |
---|---|
Author | Martijn Tonies |
Post date | 2003-03-05T15:08:52Z |
> I am sorry. I did not read it. I just try it because it is a commonReally? Creating a table inside a stored procedure?
> command to perform at any "professional" sql engine.
There's a huge difference between metadata and data... Stored
procedures are used for data-processing.
--
Martijn Tonies
Upscene Productions
>code
> > Hi German,
> >
> > > I need to create a table at a stored procedure, but it fails. The sql
> > > is the following:
> > >
> > > BEGIN
> > > CREATE TABLE 'TTEST' (
> > > ID INTEGER NOT NULL PRIMARY KEY,
> > > FIELDNAME VARCHAR(150) NOT NULL,
> > > FIELDVALUE INTEGER,
> > > DOCUMENT_ID INTEGER);
> > > END
> > >
> > >
> > > Error Message --> Token unknown CREATE
> > >
> > > How can I perform this ?
> >
> > Could you tell us where in the documentation you read that this was
> > possible? 'Cause we have to fix that documentation mistake.