Error Fields

[#1]

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

[swuehl]

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.

[#3]

normally I do that

Its doenst work 

[swuehl]

Does a

LOAD * FROM ... ;

work?

[#5]

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;

//

//

[MayilVahanan · Accepted solution]

Hi

Try like this

LOAD  * FROM $(FilePath)\Dev\PEE_ref.QVD (qvd); 

And check the fields in qvd once.

[#7]

I dont Know Why But Its Work