Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File: c:\windows\temp\12340505.tmp
Message
From
27/11/1997 18:45:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
File: c:\windows\temp\12340505.tmp
Miscellaneous
Thread ID:
00062626
Message ID:
00062626
Views:
99
Is there anybody how can tell me why when the maksimallønn=.T. everything is ok.
And when the maksimallønn=.F. I get the following error:
File 'c:\windows\temp\11602495.tmp' does not exist????????


IF maksimalønn=.F.
SELECT p3.dato,p3.ansatt,p3.ordre,p3.skift,;
p3.avdeling,p3.jobb,p3.fastlonn,p3.fastdel,;
p3.pverdi,p3.timer,;
IIF(p3.timer>0, ;
IIF(p3.bmin=.T., ;
IIF((p3.fastdel+p3.pverdi)/p3.timer>minlønn,(p3.fastdel+p3.pverdi)/p3.timer,minlønn), ;
IIF((p3.fastdel+p3.pverdi)/p3.timer>grunnlønn,(p3.fastdel+p3.pverdi)/p3.timer,grunnlønn)),0000.00) AS snittlønn;
FROM proshoyv13 p3;
WHERE .T.;
INTO CURSOR andreprodukt1
ELSE
SELECT p3.dato,p3.ansatt,p3.ordre,p3.skift,p3.bmin,;
p3.avdeling,p3.jobb,p3.fastlonn,p3.fastdel,;
p3.pverdi,p3.timer,;
IIF(p3.timer>0, ;
IIF(p3.bmin=.T., ;
IIF((p3.fastdel+p3.pverdi)/p3.timer>minlønn,(p3.fastdel+p3.pverdi)/p3.timer,minlønn), ;
IIF((p3.fastdel+p3.pverdi)/p3.timer>grunnlønn,(p3.fastdel+p3.pverdi)/p3.timer,grunnlønn)),0000.00) AS snittlønn;
FROM proshoyv13 p3;
WHERE .T.;
INTO CURSOR proshoyv14

SELECT p3.dato,p3.ansatt,p3.ordre,p3.skift,;
p3.avdeling,p3.jobb,p3.fastlonn,p3.fastdel,;
p3.pverdi,p3.timer,;
IIF(p3.snittlønn>maxlønn,maxlønn,p3.snittlønn) AS snittlønn;
FROM proshoyv14 p3;
WHERE .T.;
INTO CURSOR andreprodukt1

ENDIF


IF USED('andreprodukt')
sele andreprodukt
USE
ENDIF

USE (dbf('andreprodukt1')) AGAIN IN 22 ALIAS andreprodukt && error is trapped here!



Best regards

Per Simmersholm
Next
Reply
Map
View

Click here to load this message in the networking platform