>Sorry, the call to cursorgetprop returns a fully qualified path, try this:-
>
>? juststem(cursorgetprop("database", "tablename"))
>
>BTW "database" is the property and not the name of a database.
I understand that, but it returns rather or not the view is in the database, not if it is currently in use right? I'm trying to figure out if I have to open(use) or select the table(already in use).
As I say, I believe the answer is to prepend the database name to the alias and then double check the alias to see if the view is already in use for this database.
Thanks anyway!
--Todd Sherman
-Wake Up! Smell the Coffee!