Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Evrybody
I have this Error , i m bloqued
//// Chargement des références
PEE_ref:
LOAD
[ref PEE matricule],
[ref PEE id ss],
[ref PEE nom],
[ref PEE prenom],
[ref PEE Créé le]
FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);
RefPee:
NOCONCATENATE
LOAD
@6 as [ref PEE matricule],
@5 as [ref PEE id ss],
@2 as [ref PEE nom],
@3 as [ref PEE prenom],
'$(ProcessTime)' as [ref PEE Créé le]
FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]
(biff, no labels);
STORE RefPee INTO $(FilePath)\Dev\RefPee.QVD;
drop table RefPee ;
CONCATENATE (PEE_ref) LOAD
*
FROM $(FilePath)\Dev\RefPee.QVD (qvd)
WHERE NOT Exists([ref matricule]);
STORE Signalitique_ref INTO $(FilePath)\Dev\Signalitique_ref.QVD;
//Utile 1 fois pour iniatialiser le projet
//PEE_ref:
//LOAD
// @1 as [ref PEE matricule],
// @2 as [ref PEE id ss],
// @6 as [ref PEE nom],
// @7 as [ref PEE prenom]
//FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]
//(biff, no labels);
//
//STORE PEE_ref INTO $(FilePath)\Dev\PEE_ref.QVD
Thank U
Hi
Try like this
LOAD * FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);
And check the fields in qvd once.
Have you double checked that this field is part of the QVD?
And that it is correctly spelled (two accents? Cases?)?
edit:
You can use the script wizard to open the file and select the correct fields.
normally I do that
Its doenst work
Does a
LOAD * FROM ... ;
work?
The Programme Bloque in the creation of the table , I dont know why ??
PEE_ref:
LOAD
[ref PEE matricule],
[ref PEE id ss],
[ref PEE nom],
[ref PEE prenom],
[ref PEE Créé le]
FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);
////To initialise the project
//
//PEE_ref:
//LOAD
// @1 as [ref PEE matricule],
// @2 as [ref PEE id ss],
// @6 as [ref PEE nom],
// @7 as [ref PEE prenom]
//FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]
//(biff, no labels);
//
//STORE PEE_ref INTO $(FilePath)\Dev\PEE_ref.QVD;
//
//
Hi
Try like this
LOAD * FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);
And check the fields in qvd once.
I dont Know Why But Its Work