Back to Four Js Website
Four Js Customer Forum
Subscribe for automatic updates:
RSS
Sign in for full access
|
Help
Four Js Development Tools Forum
>
Discussions by product
>
Genero BDL
>
BDS - Genero Migration - SQL and precision
Most recent posts
Pages: [
1
]
« previous
next »
Reply
|
Print
Author
Topic: BDS - Genero Migration - SQL and precision (Read 7496 times)
Stephen T.
Posts: 114
BDS - Genero Migration - SQL and precision
«
on:
October 25, 2013, 10:40:32 am »
This is akin to the scaling issue.
If something is SUM'd (or presumably any SQL command that performs arithmetic) and the value exceeds the scale (precision) of the target variable, in BDS the code continues and in Genero the program aborts with a precision error.
The problem was noticed on SUMs - hence its use in the example below (I know it's not necessary ;-)).
IE code extract:
DEFINE l_total DEC(8,2)
...
SELECT SUM(1000*1000) INTO l_total
FROM some_table
DISPLAY 'Got Total (',l_total,')'
Pages: [
1
]
Reply
|
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General
-----------------------------
=> General Discussion
=> Ask Reuben
=> WWDC21
-----------------------------
Discussions by product
-----------------------------
=> Products announcements
=> Genero BDL
=> GWS
=> GAS and GBC
=> GDC
=> Genero Mobile for Android or iOS
=> Genero Studio
=> Reporting tools (GRW, GRE)
-----------------------------
Jobs
-----------------------------
=> Jobs
Powered by SMF 1.1.21
|
SMF © 2015, Simple Machines
Loading...