General information
Category:
Coding, syntax & commands
Just noticed: How come you have a 5 digit tmp file name? Is this a real result from DBF() function? Is this in Visual FoxPro?
I saw temp file names shorter than 8 digits only in FoxPro 2.6 for Unix. Until now. :)
Vlad
>>>Hi All!
>>>
>>>Im running my app with some Select INTO CURSOR.
>>>
>>>Sometimes I get the above error from VFP my code samle is as this:
>>>
>>>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;
>>> INTO CURSOR andreprodukt1
>>>
>>>IF USED('andreprodukt')
>>>sele andreprodukt
>>>USE
>>>ENDIF
>>>
>>>USE dbf('andreprodukt1') AGAIN IN 22 ALIAS andreprodukt // here I get an error but not in all
>>>situations??
>>>
>>>Best regards
>>>
>>>Per Simmersholm
>>
>>The file for a cursor may or may not be a file on the disk. You need to:
>>
>>USE (dbf("andreproduckt"))...
>>
>>Vlad
>
>Thanks for your reply!
>
>It did not work!
>
>The funny thing is that this app where the problem occure is much shorter than the original app (with less cursor)
>
>Another thing is that when I put this code earlyer in my app:
>
>SELECT avdeling.*,job.jobnavn,job.jobnr,job.akkbehand,;
> lonnsart.lønnsartnavn,lonnsart.lønnsartnummer,;
> lonnsart.behandling;
> FROM avdeling,job,lonnsart;
> WHERE avdeling.avdnr=job.avdeling;
> AND job.lønnsartnr=lonnsart.lønnsartnummer;
> INTO CURSOR prtavdjob1
>
>
>IF USED('prtavdjob')
>sele prtavdjob
>USE
>
>ENDIF
>
>USE (DBF('prtavdjob1')) IN 12 AGAIN ALIAS prtavdjob
>SELECT prtavdjob
>INDEX ON STR(avdnr,4)+STR(jobnr,4) TAG avdnr
>
>The error message occured in a different place later in the .prg file.
>
>Best regards
>
>Per Simmersholm
Previous
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