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.