General information
Category:
Coding, syntax & commands
Title:
File: c:\windows\temp\12340505.tmp
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
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