02-28-2024 12:34 PM - edited 02-28-2024 12:36 PM
I just wanted to run a query using literal BIGINTS (843529180000 and 843529190000) in SAP Business One and I got this error:
1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10811 Numeric overflow for parameter/column 'Job de programación back end' (OBSJ) (1) source type BIGINT, target type INT4, value '843529180000'
2). [SAP AG][LIBODBCHDB DLL] Numeric value out of rang
Reproducible using:
SELECT 843529180000 FROM DUMMY;
In DBeaver it works,
Here I read about using suffixes for bigint but it did not work neither, I got syntax errors:
Version info: SAP Business One 10.0 version for SAP HANA (10.00.180) FP 2111 (64-bit)
User | Count |
---|---|
101 | |
12 | |
10 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.