Speed would not be an issue if you define you keys correctly, so you only
need 1 detail table.

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



yes it does.

the restriction for performance is: it is required to create a
new detail table for any new master record.


thanks,
german

On Wed, 5 Mar 2003, Richard Pendered wrote:

> 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/
>
>
>
> 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/