Hi Fabrice,

 

In the UPDATE and SELECT queries I see no WHERE clauses so I

presume that the tables COMPTEUR and SOCIETE only have one record?

 

Yes it COMPTEUR and SOCIETE have one record.

 

Thanks you to all, CODE=TMPCODE || TMPSOCIETE work fine.

 

Excuse me to post this message here.

 

Fabrice Vende
fabrice@...

 

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com (use PHP + MYSQL but PHP + interbase soon!!)