Hi Marcin, thanks for your answer.
I this field i need also char values, so i cannot use only numeric values. Than i have to do a work around. regards Andreas Marcin P schrieb:
You've declared the field as char,
so the values are strings and they are compared this
way.
In 9999 the first position (9) is bigger than
the first position of 10000(1), so the result is OK.
If you want to compare the numeric values - declare the field
as numeric (i.e. Integer).
Best regards,
Marcin Pytel,
Talex S.A. Poznan
Uzytkownik "Andreas Ernst" <[EMAIL PROTECTED]> napisal w wiadomosci
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi to all,
i have a strange behavior an the system:
create table masch ( lagnr CHAR( 8), primary key ( LAGNR))
insert masch values ('9999')
insert masch values ('10000')
select max(lagnr) from masch
I get the result: 9999
I expected 10000
inserting 200000...
the same result......
OS:
W2K:
SAP DB Kernel 7.3.0 Build 025-000-085-923
SAP DB JDBC Driver, SAP AG, 7.3.0 Build 029-000-087-559
and
SuSE Linux 8.0 with the Build 025-xxx .... and the same JDBC-driver
So i installed on the W2K:
SAP DB Kernel 7.3.0 Build 030-000-088-243
SAP DB JDBC Driver, SAP AG, 7.4.4 Build 001-000-156-754
But i got the same result.
With this funktion i increase the number of machines, at this moment i
got a problem, that i cannot add machines.
Any help will be nice!!!
regards
Andreas
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
