Subject Re: [firebird-support] best way of selecting some records of a table
Author Fulvio Senore
What about storing the IDs in memory instead of writing them to a
temporary table?
You could use an array or something smarter like a c++ vector, if
available in Delphi.

Fulvio Senore

Sergio H. Gonzalez ha scritto:
> Hello, I want to implement a very normal task... Lets say the user is generating
> report with some customers' movements and he/she select some of them to print.
> In the past I did it, with a field "selected" in customer table. But I know that
> this is a very bad practice in a multiuser enviroment. I have FB2.1 and I know I
> have temp tables now and I could create a table and store the selected IDs in
> there. I've never did it before, and don't know how to do it. I use IBX/Delphi
> 6. I have no component to create a temp table. How can I create it? Should I
> delete the table after using it? Is there some example in the net about how to
> work with Temp Tables in FB ? Is that aproach, the best way to selec some
> records of a table? Thanks!! -sergio
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
>
>