Le lundi 16 f�vrier 2004, Zabach, Elke a �crit...
bonjour,
> > sqlcli TROUPEAU=> SELECT CHR(NUM('1')+1) FROM DUAL
> NUM(number) is of no use.
> Try CHR ( FLOAT(1, n) + 1) FROM DUAL
> with n being a number between 1 and 38 according to your needs.
The value is string, picked with SUBSTR from a key whose format is
NNNN-seqNumber.
And I would like to increment, if necessary, seqNumber. So I must
convert the char '1' (as an example, it could be '19'), to number 1,
within a dbproc, if possible, to get a 'computed' new key.
If not, Python will compute the key.
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
