>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

Per, you might be getting a filtered table instead of a true cursor in your first SELECT statement. Try adding the clause NOFILTER to each select. It won't hurt, might help. Usually this is not a problem when you have one field with the AS clause, but here (I think) you are using a real field name.

HTH
Barbara