AW: iNav Sql script problem

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Select Edit --> Execute Close all Results

... and drop and recreate your view

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Monday, 31. January 2011 10:25
An: Midrange Systems Technical Discussion
Betreff: iNav Sql script problem

Hi,

On an earlier thread, I learned that pageing down after executing a select
was in fact scrolling through the cursor.

Now my irritating problem is that I've created a view. Then I do a select on
that view. Now I find that my select needs to evolve, so i want to change
the view. I cannot drop the view as the cursor is still open from the
previous select.

All I can do is copy my scripts to a new window, and close the existing
windows to liberate the cursor, then start again.

Is there a command I can use to close the cursor on the view?

Thanks