Home » Developer & Programmer » Forms » Numeric overflow in forms 6i (forms 6i)
Numeric overflow in forms 6i [message #361428] Wed, 26 November 2008 06:24 Go to next message
Spiritual
Messages: 18
Registered: July 2008
Location: Pakistan
Junior Member

HI

I have a problem with numeric field in form 6i can anyone solve this.

Proble is that when i run form below mention values is done absolutly

Start no end number counter
342160383 342160484 8941006020202975594

when i add one numeric in start number and end number like this

Start no end number counter
3442160383 3442160484 8941006020202975594

its not working.
how can i solve this proble

regards
  • Attachment: CHECK.fmb
    (Size: 48.00KB, Downloaded 142 times)
Re: Numeric overflow in forms 6i [message #361445 is a reply to message #361428] Wed, 26 November 2008 07:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Proble is that when i run form below mention values is done absolutly

I'm sorry, but I don't understand the problem.
Re: Numeric overflow in forms 6i [message #361552 is a reply to message #361445] Wed, 26 November 2008 23:08 Go to previous messageGo to next message
Spiritual
Messages: 18
Registered: July 2008
Location: Pakistan
Junior Member

from and to value not support in 99999999999 value

first run attached file logon scott/tiger

first time put value into from and to text field e.g

from value 342160383 and to value 342160484 and third filed value is 8941006020202975570 and press run button its run perfectly
ok

in 2nd clear block and increase one digit into from and to filed value

like this from values := 3442160383 and to values :=3442160383
and 3rd field value will remain same now try to execute it.

its not work

basically i am design to form at cellulare distribution above mention value are SIM property. i want to purchase 100 sim with for looping. eg first sim no is 03442160383 and its internatioanl mobile suscriber identification number is 8941006020202975570. counter start from first value and loop will run till to value and in imsi value counter plus 1 for each loop

i think now you understand my numeric overflow problem

Regards
Re: Numeric overflow in forms 6i [message #361572 is a reply to message #361552] Thu, 27 November 2008 00:53 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Now I see ...

Check what's been said in the LOOP statements documentation about the UPPER and LOWER FOR loop bounds - it may be an integer, and its maximum value is 2147483647; yours appears to be 3442160383:
2147483647
3442160383
See? Your bounds are out of range.

What to do? Subtract your bounds (TO - FROM) and create a loop from "1 .. (to - from)".
Re: Numeric overflow in forms 6i [message #361577 is a reply to message #361572] Thu, 27 November 2008 01:01 Go to previous messageGo to next message
Spiritual
Messages: 18
Registered: July 2008
Location: Pakistan
Junior Member

can u solve this proble:
if yes then
please send me
end if

Re: Numeric overflow in forms 6i [message #361582 is a reply to message #361577] Thu, 27 November 2008 01:19 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LF
Subtract your bounds (TO - FROM) and create a loop from "1 .. (to - from)".
Previous Topic: how to convert oracle table row into txt file
Next Topic: PL/SQL and Javescript Function result
Goto Forum:
  


Current Time: Thu Dec 08 06:23:44 CST 2016

Total time taken to generate the page: 0.11210 seconds