Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

DECIMAL

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
RVL
Asked:
RVL
1 Solution
 
pcelbaCommented:
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
 
CaptainCyrilFounder, Software Engineer, Data ScientistCommented:
9.9999 is length 6 decimals 4.
0
 
Olaf DoschkeSoftware DeveloperCommented:
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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now