Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Infrequent error on index
Message
From
15/05/2006 17:15:25
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
15/05/2006 10:46:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01121907
Message ID:
01122037
Views:
14
>About once a month my user gets the follwing error:
>
>c:\docume~1\admin\locals~1\temp\5vyw003m.cdx already exists. It asks if you want to overwrite it. When the user clicks No, they get:
>
>Error encountered. Program will cancel. Program:IMPORT BALANCES Line#1464, error #12, Error Message: Variable 'NMEWICELL' is not found.
>
>Line 1464 is the last line in the following code:
>
> SELECT inmaccts.cell as CellNumber, inmaccts.inm_nme as InmateName, inmaccts.full_bal as FullBalance,;
> inmaccts.strt_bal as StartingBalance FROM inmaccts INTO CURSOR lcresult;
> WHERE inmaccts.cell >= sysfile.ccellrpt_start AND inmaccts.cell <= sysfile.ccellrpt_end
>
> SELECT lcresult
> INDEX ON (PADR(ALLTRIM(cellnumber),5)+inmatename) TAG nmewicell
> SET ORDER TO tag nmewicell
>
>It sounds like windows may be trying to reuse temporary filenames? Any ideas appreciated.

Try to Set order to nmewicell, without the word "tag".

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform