Solved

DECIMAL

Posted on 2013-01-17
3
296 Views
Last Modified: 2013-01-21
Hi,

we are using VFP9 the one column we have called ID has we would like to change it to the NEW_ID column

ID                                 NEW_ID
0.21                              0.2100
4                                   4.0000
0.30                              0.3000
5                                   5.0000
0
Comment
Question by:RVL
3 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
Comment Utility
Hi

Open the table exclusively and modify the structure:

USE YourTable EXCLUSIVE
MODIFY STRUCTURE

and change the ID field size to the appropriate values and name.

The new field size should have 4 decimal places and the total field size should reflect the maximum stored number.
0
 
LVL 27

Expert Comment

by:CaptainCyril
Comment Utility
9.9999 is length 6 decimals 4.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
Comment Utility
The old ID column already seems a float or numeric column, the formatting of the output is not the job of a browse or the database. That's a job of your form, report, whatever displays the id.

So all you need is an altering of the field name. If it's part of a relation to other tables that wouldn't work without side effects, I'd rethink this.

Bye, Olaf.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now