>>>>What is the correct syntax for use a view
>>>>in a database that is already open
>>>>
>>>>View name would be Vbbjthead
>>>Hi Neyenesch.
>>>
>>>Same syntax as using a table. Of couse, the database not only has to be open, it also has to be the current database.
>>>
>>>USE Vbjthead IN 0
>>>
>>it has to be open but you don't need it to be current
>>you can :
>>USE myDatabase!vbjthead ...
>>
>>also note that you can also use the NOREQUERY clause if you don't want to refresh the data
>>
>>Arnon
>
>Would you use that same idea in SQL Select Statement?
>
>SELECT *;
>FROM Vbjthead;
>WHERE ljob >" 123";
>ORDER BY ljob
>
>OR is this correct
>
>SELECT *;
>FROM PSIDB!Vbjthead;
>WHERE ljob >" 123";
>ORDER BY ljob
If you have just one database in your app, and it is the current database, there is no big reason to include the database prefix, (but it will not hurt either :)
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison