>Is there an easy way of telling if a table (in a multiuser environment) is already opened in the current data session under an unknow alias (don't ask)? I could always scan though all open work areas and test the table name of the alias, but that seems like the long way of getting the answer.
Fred,
AUSED() returns the workareas and aliases of the files opened in the current data session or specified one. Simply use that in conjunction with DBF() to determine if a file is in use under a different alias (i.e.: IF lcfile = DBF(a_used[lni, 1])). AUSED() also will let you indicate the datasession number.
George
Ubi caritas et amor, deus ibi est