I have a six digit number that I need to insert the letter “x” into a variable – like this 1234x56. The first 4 digits identify a department, the last two digits represent a record sequence number. In this case, a record needs to be deleted, but kept in the database and sorted to the bottom of the list for the department. So placing an alpha character in this position allows the database to sort correctly. I used to do this with the sandwich procedure and put the alpha character in front of the number – but if someone has all records selected and then sorts, all deletes go to the bottom of the database rather than stay with the department. Of course, if they remember to group the records first – it works fine. By inserting the alpha character between the department & sequence number – the database sorts correctly regardless of grouping, I’m having trouble getting my procedure to place the alpha character correctly in the variable so it can replace the existing number in the field. My procedure opens the TEO and places the contents into a variable, then replaces the data in the active TEO with the “x” inserted in the number – or at least that’s what I’d like it to do. I’m not able to figure out how to correctly define the variables contents. Here’s one example, I’ve tried many different approaches, this one quits Pan6, but I’ve seen other attempts that say “implicit”:
I’m currently in Pan 6 because my staff still use Pan6 - we’re waiting on the expandable text issue to be resolved - I know it’s on the to do list. I have done lots of conversion to PanX for all my databases and really am liking it!