I want to create a view in a database without selecting the database. I tried:

create view newview database tempdata as select * from tempdata!sometable where .t.
* and also
create view newview as select * from tempdata!sometable where .t. database tempdata

I know that you can do:

set data to temp
create view newview as select * from tempdata!sometable where .t.

I just like more compact code when possible. It seems like we ought to be able to create a view into a specific database without selecting the database after all we select into a database without having it selected.

However, I think it can't be done. Anyone able to refute this?