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:
01174176
Views:
14
>>>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform