>The views are getting created, It is the index that can't be created.
>
> When the index on statement is hit, this is when I get the error.
>
> I saw what you said about the database being on the network, so I have the >program creating the database locally and then creating the view and I still >get the "File in use" error when I try to index!!!
Since You're trying this on one machine as a second instance it doesn't really matter where the Database is located. In your case Your workstation is the server.
But, maybe it has something to do with buffering. Normally a view gets opened rowbuffered. try to force it to 1, build the index and then set it back to buffering.
Remember, once You open the View exclusively in order to build the index, You will always get the "File in Use" by any other Instance or user.
Another suggestion is to create one View for each instance like
local lc_Dummy
lc_Dummy = "V+sys(2015)
create view (lc_Dummy) as ....
use (lc_Dummy) in 0 alias
