Subject Re: [ib-support] Creating Tables Problem
Author Martijn Tonies
> I am sorry. I did not read it. I just try it because it is a common
> command to perform at any "professional" sql engine.

Really? Creating a table inside a stored procedure?

There's a huge difference between metadata and data... Stored
procedures are used for data-processing.

--
Martijn Tonies
Upscene Productions

>
> > Hi German,
> >
> > > I need to create a table at a stored procedure, but it fails. The sql
code
> > > 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.