 | Field Type |  |
 Posted: Tue Mar 02, 2010 12:55 am |
Points: 0  |
|
| kiwi |
| n00b |
|
 |
| Joined: 25 Feb 2008 |
| Posts: 9 |
|
|
|
|
|
|
 |
|
HI - Can I change a field type from character to numeric without losing all the information from existing details records with information in the field?
Thanks |
|
|
|
|
| Posted: Tue Mar 02, 2010 11:10 am |
Points: 0 |
|
| DougCastell |
| GoldMine Guru |
|
|
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
|
|
| No. You'll want to create a temporary holder field and globally-replace the information over to the other field using a suitable dbase expression to convert it from one type to the other (like VAL()) |
|
|
|
|
| Posted: Wed Mar 03, 2010 2:00 am |
Points: 0 |
|
| kiwi |
| n00b |
|
|
| Joined: 25 Feb 2008 |
| Posts: 9 |
|
|
|
|
|
|
|
|
Hi Doug - thanks for the reply and I'm pretty certain you will have picked this up but when I re-read my question I saw that I hadn't explicitly stated that this was changing the type of a field within the DetailsPlus application so just to be 100% sure  ... |
|
|
|
|
| Posted: Wed Mar 03, 2010 10:42 am |
Points: 0 |
|
| DougCastell |
| GoldMine Guru |
|
|
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
|
|
oh, nope -- I hadn't noticed it was a details plus thing! Sorry, I'm not sure about the answer in the context of DP. I suspect that you CAN do this since the underlying database field isn't going to change, but I'm not 100% sure.
sorry for sidetracking your thread!  |
|
|
|
|
ContactReview Forum Index » Details Plus
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
