Storing results of Select Statement

[matt23lucier]

I have a progress program where I query the database using a couple of select statements. My question is how do I store the data that is returned from a Select statement in progress so I can use it later on in the program?
Thanks
Matt

 

[longhair]

matt23lucier,
can you be a bit more specific?
you can store data in vars, temp tables, work tables, an external file an external db...
how much later?
how much data?
perhaps if you show the code or advise what you are attempting to do i'll be able to help.
regards,
longhair

 

[matt23lucier]

longhair,
I am writing a program that I need to pull information from a database and keep it in a table for the length of the program. Usually when I do this I do it with several for each statements. This time it can be done with a simple Select statement. My question is as follows, is there a way to store the results of a select statement in a table?
Thanks
Matt

 

[longhair]

matt23lucier,
you could try to define a temp-table and set the fields to the results of your select statement.
i do not sql just straight 4gl so i do not know if it is possible.
regards,
longhair