If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Numeric Field number of digits

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-30-12, 11:26
shaun stewart shaun stewart is offline
Registered User
 
Join Date: Jan 2012
Location: Northwest England
Posts: 2
Numeric Field number of digits

Hi Everyone,

I have a numeric field in a form that currently allows an eleven digit number. Any number larger than 11 digits is truncated. I have removed the picture and formatted it as a General number. How can I increase the number of digits allowed?

For info the specific number is 277525910102 so you can see it does not exceed the floating point range.

Thanks

Shaun
Reply With Quote
  #2 (permalink)  
Old 01-30-12, 15:12
Steve Green Steve Green is offline
Registered User
 
Join Date: Dec 2007
Posts: 282
are you asking how to make the space wider on the form? be sure to make it one bigger than what you need, to allow for the minus sign (that's how the display theory works)
__________________
--
Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies
Reply With Quote
  #3 (permalink)  
Old 01-31-12, 05:04
shaun stewart shaun stewart is offline
Registered User
 
Join Date: Jan 2012
Location: Northwest England
Posts: 2
Numeric Field Number of digits

Hi Steve,

Your prompt reply spurred me on to do some further investigation. I have now found the answer. The format (picture) of the number is read from a configuration table when the form is loaded and thus caused the issue
the picture as read from the database is:

[#[#[#[#[#[#[#[#[#[#[#]]]]]]]]]]]]]]][.#[#]]

I changed it to:

[#[#[#[#[#[#[#[#[#[#[#[#[#[#[#]]]]]]]]]]]]]]][.#[#]]

and everything worked.

Many thanks for your help

regards

Shaun
Reply With Quote
  #4 (permalink)  
Old 01-31-12, 11:57
Steve Green Steve Green is offline
Registered User
 
Join Date: Dec 2007
Posts: 282
great.. thanks for the follow-up!
__________________
--
Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On