1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| WHILE SQLFetch("QRYFACT")
dbRefpiece = SQLCol("QRYFACT", 1)
dbLot = SQLCol("QRYFACT", 2)
dbEtude = SQLCol("QRYFACT", 3)
dbRefdoss = SQLCol("QRYFACT", 4)
dbRefIMX = SQLCol("QRYFACT", 5)
IF(dbEtude <> "" AND dbLot <> "" AND dbRefdoss <> "" AND dbRefIMX <> "") THEN
sFichierEtude = ExtractString(EDIT_FTPREPETUDES,1, "/") + "/" + dbEtude + "/" + dbLot + "/" + dbRefdoss + "/" + dbRefIMX + ".pdf"
sFichierTemp = fCurrentDir() + "\TEMP\" + dbRefIMX + ".pdf"
sAttribFichier = FTPAttribute(xFTPEtudes, sFichierEtude)
IF(sAttribFichier = "ERR") THEN
FTPGet(xFTPImagerie,dbRefpiece,fCurrentDir() + "\TEMP", PBAR_FACT)
IF(FTPCurrentDir(xFTPEtudes, ExtractString(EDIT_FTPREPETUDES,1, "/") + "/" + dbEtude + "/" + dbLot + "/" + dbRefdoss + "/")) THEN
FTPMakeDir(xFTPEtudes,ExtractString(EDIT_FTPREPETUDES,1, "/") + "/" + dbEtude + "/" + dbLot + "/" + dbRefdoss + "/")
END
FTPSend(xFTPEtudes,sFichierTemp, sFichierEtude, PBAR_FACT)
fDelete(sFichierTemp)
END
END
END |
Partager