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 tempdataI 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.