I have a procedure that basically cleans up data when I enter it into a field. In Pan 6 I use a lot of Case Statements. Works fine.
I discovered that if I am on the first record and execute the procedure the procedure is executed and then the next record is activated when in Pan X. Going down one line in the data sheet.
The procedure below is culling out many steps to isolate the problem. This procedure normally is executed when a field is changed in many of the database fields.
If not on the first record then this event does not happen if there are multiple records.
If only one record the procedure works.
Because it only happens on the first record if there are multiple records selected it took me some time to isolate it. It did not happen all the time!
I have verified the problem on a virgin database too with PanX 10.2 rebooted.
Below is code:
;—Named ".StripsPasteData----culled to essence – one item Case
;this strips leading and trailing spaces and non-printable characters
;
Global FieldName
FieldName=info(“fieldname”)
Case FieldName=“E-Mail Address”
«E-Mail Address»=strip(stripprintable(«E-Mail Address»))
Endcase
Show
Message “End of Routine”
Thanks.
George