By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

reformat of 17 tables from integer to single

P: n/a
We are redoing an existing database and need to reformat
all the number fields from integer to single fixed 3.
their main thing is negative numbers and the decimal places.

Can this be done in code?

field size long -->single
format fixed
decimal places 3

Since we are going from integer to single format this should
not mess with any existing values should it ?
I can see where single to integer would but not to a larger format.
it didn't when I tried it manually.

Oct 15 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Thanks big time for all your help

On Tue, 16 Oct 2007 00:42:59 +0800, "Allen Browne"
>That's correct. If the Format has not been set, the property does not exist
yet. Hence CreateProperty().
Oct 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.