>> if used ('JobSheet') && This alias is already in use >> select JobSheet >> else >> use JobSheet again shared alias JobSheet in 0 && This would open JobSheet table in shared mode, we didn't try to check for possible errors here >> select JobSheet >> endif >>>>Second test:
>> lTableName='JobSheet' >> if used(lTableName) >> select (lTableName) >> else >> use (lTableName) alias (lTableName) again shared in 0 >> select (lTableName) >> endif >>>>
>> TableName is a field in Table called AllTables >> lTableName=evaluate('AllTables.TableName') && Get the field content >> if used(lTableName) >> select (lTableName) >> else >> use (lTableName) alias (lTableName) again shared in 0 >> select (lTableName) >> endif >>>>