Here is a slightly different approach that maintains
the same field Id.
For this example, Field1 is the name of the existing
field and Field2 is the name of the temp field.
1. Add new Field2 field and
Save.
2. In your DBMS
query tool run: UPDATE My_Form SET Field2 = Field1
3. Delete the old field.
Save.
4. Create new field with same field Id as the
original.
5. In your DBMS query tool run: UPDATE My_Form SET
Field1 = Field2
6. Delete the temp Field2 field.
Using SQL bypasses filter processing and usually only
takes seconds to run. There is also a field Id changer tool
available on the community download site you could use
instead.
Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J
Sent: Monday, October 16, 2006 12:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question?
Sara,
The only way I have done this in the past is
to fist create the new field. Run an
escalation to populate the data from
the existing field you want to change
to the new field. Once completed, delete
the old field.
You need to ensure that the data you are putting in the
few field is valid of that field.
There
may be other methods but this worked for me.
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
mailto:[EMAIL PROTECTED]
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sara abate
Sent: Monday, October 16, 2006 11:38 AM
To: arslist@ARSLIST.ORG
Subject: Question?Hello List,Is there anyway that I don't know to convert an existing field type to another field type, eg. character field to numeric field? I just want to check with you before I tell the user it is impossible.Thanks,
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. __20060125_______________________This posting was submitted with HTML in it___