>As anyone trying to use it :) What I do is to first write my SQL in command window or a dummy code window and get the correct SQL that I want. Something like :
select .... from ... where ... && No into ....
When I'm satisfied I add 'create SQL view cVievNAme as ' in front of select and excute (database is open at the moment). Then either I use Erik Moore's eview or gendbc to get programmatic version of the update syntax, retouch and recreate. In order to prevent myself screwing the view in designer I generally place a 'force' clause after 'from'.
Cetin
>

Thank you.
It's ashame that we have to resort to these type of things, but what ever works.... :(