I gave a group of companies a stand-alone version of funds plan management system (pb + access), there are about 30 departments use,
The question now is: due to demand change, the money must be field (type: currency) decimal places from the original two to four,
Want to use the SQL statements in the program, and then compiled PBD and exe with e - mile to each department,
Request premise is not to delete the original data, please give a SQL statement or other flexible method
Online, etc...

CodePudding user response:

In exe, judge database decimal places, if two are updated to four,
Update method is to alter table

CodePudding user response:

Modify the table structure, drawing using this form of DW, send them to customers after a recompile,

CodePudding user response:

1/f, please give the full SQL statements example
The second floor is very funny, I just want to know what did you do the work before the first comma

CodePudding user response:

Continue to cross-examine online, etc

CodePudding user response:

up

CodePudding user response:

Decimal places from the original two to four
===========================
By short variable-length relatively easy to implement, can be directly into the enterprise manager manually modify,
Alter table table_name
(column column_name number (8, 4))

CodePudding user response:

The round ()