General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>What would force a table to be opened with READONLY=.T.? I am performing the following command:
>>>>
>>>>USE (pcFileName) IN 0 AGAIN ALIAS mytable SHARED
>>>>
>>>>This is being executed in the Init method of a form with the variable 'pcFileName' being passed as a >lparameter.
>>
>>>>Is it a real table? Is it open somewhere else? If yes, what is the mode? Do you have a read-write access to
>>>>that file?
>>
>>The table is a form (scx), it is not open anywhere else and I have read-write access. I can open the form with >>the MODIFY FORM command; but if opened via my form Init method as above it is being opened readonly.
>>
>Are you passing it with the full path and extension? I just tried in command window
>
>USE GETFILE('scx') IN 0 AGAIN ALIAS mytable SHARED
>
>it woirked just fine.
There is a full path to the file. I can open (USE) the form, but it is READONLY. I have worked some more with this and it seems it is intermitten (do not know what's causing the behavior). So, my question is what would cause a readonly on a USE command? From the documentation of the USE command there is not an option for opening in READONLY mode (just SHARED or EXCLUSIVE). I can open the form normally with MODIF FORM so I know that the file is not marked READONLY (and can see from attributes in Win Explorer).
I would expect that the only way to have READONLY on a table (in this case a USEd form) is if the file attribute is READONLY; are there any other ways?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only