how can i convert integer to code

magnifique

i have a table that has a unique field of type integer containing data i imported from SQL server and i want to pull the data into my client ledger entry table but this time assigning the new client numbers to it and in order to do this am comparing in my code that if the old client number is equal to the the client number in the table i imported into the native database then it should assign its corresponding number in the client table into the the client ledger entry table.
i get this error espression type integer cannot be converted to code value
](*,)

fl

Hi,

To convert an integer to code, you can use

code:=format(integer);

Regards,

Francois

magnifique

mon ami merci tres beaucoup, ca marche bien.

DenSter

c'est magnifique n'est-ce pas?

Marije_Brummel

Je ne parlez pas bon francais. 8-[

And that's the only thing I know