I have an LE, Info 1, a regular text field, and I wanted to change it to a text editor LE. I can't do that, so I created a new text editor LE, Info 2 with the idea to mass update all the information from Info 1 to Info 2.

I did a search on all records with data in Info 1 using "/".

I selected Mass Update (Database), then selected Info 2 from the list. I then doubledclicked "Info 2" from the list and it opened the Program Editor. I put in a simple code:

var vTemp as String

vTemp = Info 1

FormFieldValue("Database", "Info 2", 0, vTemp)
 

I then cilcked "Run", to run the Mass Update.

It was going very slowly so I went away for awhile, I came back after awhile and it was frozen and the Server was no longer open. So, I closed everything out, restarted the Server, unlocked the database, and restarted the Application.

I checked to see if any of the info had transferred over to Info 2 and it had for about 1,000 or so records. So, then I did a search on the remaining records by putting "/" in Info 1, and "=" in Info 2.

The server then disconnected again and closed completely and  but the client was still opened but disconnected until it eventually closed. I found that I could retrieve all those records with data in Info 1 still. However, there was one particular record, I'm guessing the one it got stuck on, that anytime I would retrieve the record it would cause the Server to disconnect.

Is there a more efficient or quicker way to do this? All I want to do is either change Info 1 into a Text Editor LE or transfer all data of Info 1 to Info 2 which is a Text Editor LE. I'd prefer not to bind Info 2 to Info 1 and then delete the element because I don't want to have a lot of extraneous LE's in the application. I'd prefer to do a mass update if that's possible, unless there's a better way.

But if I then go into "Manage A Database" and run a batch to delete the Info 1 LE, will I then lose the data from Info 2?

Ok thank you, I actually think I found a way to fix the problem too. There is a place where you can change a text field from "single line text" to "multi line text" and that was what I needed to do but didn't see the feature before.