469,088 Members | 1,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

converting field type in active database

When I designed my db in several tables I used unsigned integer fields
to hold an integer that each bit was a 'flag'. Now I realize that the
set field type does just what I was trying to accomplish. Is it safe to
convert the field(s) from uint to set and keep their current values?

Obviously all external programming (queries) will have to be adjusted,
but it seems to make more sense to use the set type.

Bill
Oct 30 '05 #1
2 1295
On Sun, 30 Oct 2005 17:38:01 +0000, William Gill wrote:
When I designed my db in several tables I used unsigned integer fields
to hold an integer that each bit was a 'flag'. Now I realize that the
set field type does just what I was trying to accomplish. Is it safe to
convert the field(s) from uint to set and keep their current values?


Probably! Maybe!

But why not just insert a brand new field with your set type then:
UPDATE {table}
SET {NewSetField} =
See how it works out alongside the original int field.

When you are happy everything works, you can delete the old
int field.
Thomas Bartkus
Oct 31 '05 #2
With the added benefit of having both fields to test against in external
queries, until I get everything updated.

Thanks,

Bill

Thomas Bartkus wrote:
On Sun, 30 Oct 2005 17:38:01 +0000, William Gill wrote:

When I designed my db in several tables I used unsigned integer fields
to hold an integer that each bit was a 'flag'. Now I realize that the
set field type does just what I was trying to accomplish. Is it safe to
convert the field(s) from uint to set and keep their current values?

Probably! Maybe!

But why not just insert a brand new field with your set type then:
UPDATE {table}
SET {NewSetField} =
See how it works out alongside the original int field.

When you are happy everything works, you can delete the old
int field.
Thomas Bartkus

Oct 31 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Christopher W. Douglas | last post: by
6 posts views Thread by Larry R Harrison Jr | last post: by
2 posts views Thread by Asbjørn Ulsberg | last post: by
9 posts views Thread by Pam Ammond | last post: by
5 posts views Thread by amitbadgi | last post: by
12 posts views Thread by Frederik Vanderhaeghe | last post: by
5 posts views Thread by Alan T | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.