I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Overflow Errors

Overflow Errors in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Overflow   Overflow Errors  
Gary Vonckx
 (Inactive)
Ft. Pierce, Fla. USA
Hello all,

Just wanted to contribute an answer for all!

For the last 10 days I have been fighting an "Overflow Error".

I was trying to insert data from 2 tables into 1 table. I was getting the error "Overflow:Source is to large(positive or negative) for destination"

At first I tried increasing block size on the destination table. I also emptied the table to create space in it after copying it to a new table name still to no avail.

Finally I went to the Prestwood Knowledge base and did a search for overflow. The search directed me to Mike's book "Paradox 9 Power Programming" chapter 7.

In this chapter Mike explains in a very clear manner as to how Paradox handles numbers in memory. 1. Small Int takes 2k in memory 2. Long Int takes 4K in memory and 3. Number which goes to 18 significant digits(10 to 4930th power!!!) no space requirement given for RAM.

In my code for the particular job I was running there was a number cast as an INT which was limiting memory allocation. After changing the number to be cast as a "Number" all was well.

The biggest thing I learned was to read the error and to understand what it was telling me! As I mentioned I thought that it was a table problem to start with but this as you know now was a mistranslation of the error.

Thanks for the help all!
 Posted 13 years ago (Thread Starter)
Comment Quote
About Gary Vonckx -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #11385, 1 replies
Thread Started 1/12/2006 6:39:00 AM
View Counter=1921
Last Reply Posted 12/8/2007 12:36:19 PM)
Location=Ft. Pierce, Fla. USA  
Joined=18 years ago   MB Posts=23  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
Thanks for the tip Gary and thanks for the kind words too. Much appreciated. In addition to posting tips here on the message boards, you can post tips to our Paradox tips page (part of the Paradox group here). I mention this just cuz I'm trying to beef up the Paradox group content.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #12333 (Level 1.1)  Reply to 11385
Thread Started 12/8/2007 12:36:19 PM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=70   BLOG, Topics=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1103A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11385 Counter
1921
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech