Therein is the problem. MS SQLServer does a lot of things differently than
IB/FB and IB/FB does many things differently than MS SQLServer.
IB/FB simpy does many things "better" than MS SQLServer and therefore does
need (usually) temp. tables.
If you define your problem(s), that is why you need the temp. tables,
someone will show you the way to do it in IB/FB.
The task of converting from MS SQLServer to IB/FB is not always trival and
requires work, due to the differences between the two database designs.
After determining the amount of work required, you may, or may not, decided
to continue with the conversion. After all, as you pointed out in you
e-mail:

"currently running with m$ sql server and WORKS VERY WELL."

Your current solution works "VERY WELL."



Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...

-----Original Message-----
From: PODESTA Mariano APRE [mailto:SIDTMPO@...]
Sent: Tuesday, June 25, 2002 1:07 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] creating tables


simply i need to create tables because:
i'm trying to migrate a system to ib/fb that is
currently running with m$ sql server and WORKS VERY WELL.
the database uses temp tables and i can't find a way to do
something (similar or not) to obtain the same result.

> -----Original Message-----
> From: PUB: Martijn Tonies [mailto:m.tonies@...]
> Sent: Martes, 25 de Junio de 2002 17:01
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] creating tables
>
>
>
>
>
> > there are many cases where the best solution are temporary tables.
> > one could be: making a dynamic pivot?
> >
> > please do not answer with another question.
>
> Why not? Many people come asking about a problem they think
> is the solution - while in very many cases, those people are often
> better of with a completely different solution. So, instead of asking
> questions about the 'solution you think is right', ask questions
> about your attempted solution AND describe your problem and
> the reasons why you came to that [attempted] solution [that fails].
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."

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/