Did you come across anything where a SQL-SELECT on a View fails to return the current values.

SQL - SELECT operates on the contents of the file on disk and does not "see" what is in the buffer.

Also I get a random error regarding one of the 2 GOTO statements, I am not able to reproduce it everytime. Could you help.

Probably not. I am a developer, not a magician < g >. I am unable to fix my own bugs if I am unable to reproduce them.