Re: Insert in temporary table

[iroyle@cix.compulink.co.uk (Ian Royle)]

In-Reply-To: <9503217984.AA798481891@stoffel.pica.nl>
Try using -c1 next to Begin-select & begin-sql i.e. begin-select -c1 & 
begin-sql -c1. This forces SQR to use the same connection to the server & 
therefore see the temp table.

If you're accessing the temp table in a subquery with begin-select you 
can't do this though, you would need to restructure your report so this 
is not the case.

Ian Royle