>VERY interesting phenomenon - using a common data environment, using an SQL Select statement, after releasing the form it was called from, required a 'set filter to' statement to 'reset' the data to be able to 'seek' in it again without retaining a 'set filter to xyz' that was never issued! I have used SQL Select statements endlessly before, but nevvver with this result.
>
>ANY ideas??
>
>Thanks.

EVERY SQL command should include NOFILTER or READWRITE clause.