DBFORMAT

Dear specialist, With the environment variable we can change 'the decimal point is comma'. This works fine but the inputs must be done with a comma instead of a point. Our customers are not used to use the comma, so that will be a great change. Therefore I was looking for another solution. So I want to keep the input with the standard Informix manner, but the printing should be done in another way. Has anyone has a splendid idea for this problem? exemple: input should be done with 12345.33 when printing as using "###,###.##" the system should print 12.345,33 Thanks, Danny

nieuwsgroepen <Fidelity@fidelity-soft.be> a eécrit dans le message news:88dtm5$qsj$1@trex.antw.online.be... > Dear specialist, > With the environment variable we can change 'the decimal point is comma'. This works > fine but the inputs must be done with a comma instead of a point. Our customers are not > used to use the comma, so that will be a great change. Therefore I was looking for > another solution. So I want to keep the input with the standard Informix manner, but the > printing should be done in another way. > Has anyone has a splendid idea for this problem? > exemple: input should be done with 12345.33 > when printing as using "###,###.##" the system should print 12.345,33 If the input is a separate program from the printing and you can wrap the programs in a shell script, then export DBFORMAT before running the program - and set it appropriately for the print or input format that you need. Say for instance using ksh something like: ( # in a subshell so as not to set DBFORMAT for the calling environment export DBFORMAT=":.:,:" # export anything else that might be handy or read in an environmentfile # then run the print program cd $PROGPATH/prog ./prog.4ge ) I think - apologies if I've misremembered some of the details... I can't try it out here. -- Andrew Pearson - un animal avec beaucoup de fonctions interactives. Parlez et riez ensemble. Il connait 800 mots et bruits. Réagit à la lumière et au bruit. Ses mouvements sont très réalistes! Version anglaise.