(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Too many zeros in number fields
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Too many zeros in number fields (Read 579 times)
freinis
Member
*
Offline


No personal text

Posts: 3
Joined: Jan 22nd, 2004
Too many zeros in number fields
Jan 23rd, 2004 at 3:23am
Print Post Print Post  
I migrated my Q&A database to Sesame successfully.  However, when I do a search/update in Database Manager, a field, Commission Percentage, has too many zeros.  I tried to fix this in Designer.  I made a restriction,?.??,for that field, hoping that this would reduce the number of characters to three.  Now when I do search/update, I receive the following message: "Warning, the following elements do not meet restrictions. Do you want to save this record and continue?"  Please help!
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Too many zeros in number fields
Reply #1 - Jan 23rd, 2004 at 3:52am
Print Post Print Post  
1) Go back into Designer and remove the restriction specs you added.

2) While the layout elements are still selected, click on the FORMAT tab under PROPERTY EDITOR on the left side of the screen.

3) Set the DISPLAY FORMAT drop down list to CUSTOM FORMAT.

4) From here you can use the DECIMAL PLACES drop down list to select the value you need.

5) Don't forget to save the changes before exiting.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge