FiveTech Support Forums

Hi all,
I'm trying to simply read data from a dbf file and this error is doing me crazy.
The point is this: if I put the dbf into the same folder of this sample then it runs well, but it I try to read the dbf from a different folder the error in subject appears.

Any ideas ? Thank you in advance.

function Main()
local aArray,cFileStabili,fine

cfilestabili:="c:\drive_k\b_test\summa\stabili.dbf" && this way it doesn't runs and the error base 1002 appears
*cfilestabili:="stabili.dbf" && this way it runs well
aArray:={}

USE &cFileStabili ALIAS Clients
SELECT Clients

GO BOTTOM

FINE:=RECNO()
for i:=1 to fine
    go i
    dato1:=Clients->F0001
    dato2:=Clients->F0002
    dato3:=Clients->F0003
    dato4:=Clients->F0004
    dato5:=Clients->F0005
    dato6:=Clients->F0006
    dato7:=Clients->F0007

    aadd(aArray,{dato1,dato2,dato3,str(dato4,5)+"/"+dato5,dato7,dato6})
next
use

msginfo("Do it")

Marco,

Try so:

IF !File(cFileStabili)
MsgInfo("File does not exist !", cFileSatbili)
ENDIF

USE &cFileStabili ALIAS Clients
IF NetErr()
MsgInfo(cFileStabili+ CRLF+;
"FError(): "+ Transform(FError(), "")+ CRLF+;
"DosError(): "+ Transform(DosError(), "")+ CRLF+;
"")
RETURN NIL
ENDIF

SELECT Clients

Regards

cfilestabili:="c:\drive_k\b_test\summa\stabili.dbf" && this way it doesn't runs and the error base 1002 appears
*cfilestabili:="stabili.dbf" && this way it runs well
aArray:={}

USE &cFileStabili ALIAS Clients

Hi,
solved with the hmpaquito trick ... it's crazy !!
Thank you.