Subject | best way of selecting some records of a table |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2008-08-12T20:14:05Z |
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
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