>You can't just from the name but if you open it, you can determine the database with CURSORGETPROP("Database","Lender"). If it is a free table, this will return "".
Great.
Thank you, Larry.
>>Hi Larry,
>>
>>Thanks a lot for your response. The code seems to work (I haven't tested yet, because I switched to another application).
>>
>> Now I have another problem:
>> This is the code from DE. After getfile I want to know, which database belongs opened table and SET DATABASE to this DBC.
>>
>>IOW, is it possible to determine database by table's name?
>>
>>
>>
>>********************************************************************
>>* Description.......: DE.BeforeOpenTables
>>* Calling Samples...:
>>* Parameter List....:
>>* Created by........: Nadya Nosonovsky
>>* Modified by.......: Nadya Nosonovsky 04/06/2000 01:50:18 PM
>>********************************************************************
>>set talk off
>>local cFileName
>>if type('pcTable')='C' and !empty(pcTable)
>> cFileName=pcTable
>> if type('pcDBC')='C'and !empty(pcDBC)
>> set database to (pcDBC)
>> endif
>>else
>> cFileName=getfile('DBF', '', '', 0, 'Select Table to operate')
>>endif
>>if !empty(cFileName)
>> set multilocks on
>> use (cFileName) again alias Lender in 0 shared
>> =cursorsetprop("Buffering",5)
>> this.InitialSelectedAlias='Lender'
>>endif
>>
>>
>< snipped >
If it's not broken, fix it until it is.
My Blog