Sounds like a classic master detail relationship to me

-----Original Message-----
From: German Terrazas [mailto:german@...]
Sent: 05 March 2003 15:51
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Creating Tables Problem


Hi Martijn,

The problem is as follows:

I have a table A with records referencing to a table. The problem I
have is that for any new record of A it is necesary to create a table Aj.

I can obtain the name of the new table by string concatenation and pass
the name to a stored procedure. But, that stored procedure cannot perform
a create table.

My solution is to pass the createTable query string to a delphi
DB component. I think it is better to reach a more deployment platform
independent solution.

Any other idea to do that ?

thanks !
german

On Wed, 5 Mar 2003, Martijn Tonies wrote:

> German,
>
> > Firebird do not allow:
> >
> > [1] execute 'select * from table' or execute :varstr where :varstr is a
> > varchar containing a sql statement.
>
> Luckily, Firebird 1.5 - now being tested as a beta - does support this.
>
> > [2] dynamic table creation
>
> Ugh - WHY do you need this? Then, we'll talk about better or other
> ways to solve this.
>
> > So, I think firebird is not a profesional sql engine for me to deploy
> > with.
>
> Because you can't solve your own problems and you're stuck in a
> particular way of thinking, you are telling us that Firebird isn't
> professional?
>
> Read the docs, ask questions - and we can help. Don't complain about
> things that cannot be done - or you haven't asked anything about. Let's
> be a little more constructive than that - and you will see that Firebird
> is a VERY professional database engine.
>
>
> --
> Martijn Tonies
> Upscene Productions
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/