Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » Details Plus » Field Type
Post new topic  Reply to topic View previous topic :: View next topic 
Field Type
PostPosted: Tue Mar 02, 2010 12:55 am Points: 0 Reply with quote
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
View user's profile Send private message

PostPosted: Tue Mar 02, 2010 11:10 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
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())

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Wed Mar 03, 2010 2:00 am Points: 0 Reply with quote
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 Smile ...
View user's profile Send private message

PostPosted: Wed Mar 03, 2010 10:42 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
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!

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Field Type
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin