Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack statement causes wrong error
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01173857
Message ID:
01174188
Views:
11
>>>>I changed it to:
>>>>USE L:ledger excl
>>>> PACK
>>>>and the error persists. In order for a user to be able to pack a networked file, should they be given MODIFY rights?
>>>>
>>>>
>>>>
>>>>>>In my error log, I notice a user keeps err'ing on a pack statement within an app, Is this wacky? #7 File already exists.
>>>>>>
>>>>>>code is this
>>>>>> USE &LD:LEDGER excl
>>>>>> PACK
>>>>>>
>>>>>>Addendum :I think it is a permissions issue, am looking into it now.
>>>>>
>>>>>That code doesn't seems good to me. What is the exact file name?
>>>>>Usualy [:] is put after the DRIVE letter, so I can't figured out what is the path and file name here.
>>>
>>>Yes, and Write also.
>>
>>Quite odd here, the message "File L:\ledger does not exist" now pops up. The file IS getting deleted when this user executes the code but not when I do. And I have not provided for the file to be erased!! Here is this gist of the code that is being executed.
>>
>>MQ=QUANTITY
>> MD=DETAIL
>> DELE
>>
>> USE IN ledger
>>USE L:ledger excl
>> PACK
>>GO BOTTOM
>>thisform.list1.Requery
>>THISFORM.REFRESH
>>USE IN ledger
>>USE L:ledger shared
>>
>>Any ideas?
>
>Are you both run that code with the same user account?
>I don't see anything suspicious here.
>What happens with this:
>(md is not a good name for variable :o)))
>
>lcAlias  = ALIAS() && I use this because I don't know what is your current alias
>MQ  = QUANTITY
>MD1 = DETAIL
>DELETE IN (lcAlias)
>
>
>lcLedger = DBF([Ledger])
>SELECT SELECT([Ledger])
>USE (lcLedger) EXCLUSIVE ALIAS Ledger
>PACK      IN Ledger
>GO BOTTOM IN Ledger
>thisform.list1.Requery()
>
>thisform.Refresh()
>
>SELECT SELECT([Ledger])
>USE (lcLedger) shared
>
------------------
ok, Your line "PACK IN Ledger" is where it fails with the "file already exists" error. The folder permission is read&execute,list,read,write. The file permission on Ledger.dbf is read&execute,read,write
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform