RE: iNav Sql script problem

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Birgitta Hauser
Envoyé : lundi 31 janvier 2011 12:01
À : 'Midrange Systems Technical Discussion'
Objet : AW: iNav Sql script problem

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

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