Here is a reproduction of my old PTSS report. @Mark_Sarson might be able to describe the situation he found today with phantom records due to the same issue?
Problem Reference: 39361
Date Received: 2012-05-30
Status: Opened for Review
Fixed in Build Number:
Build No: 89285
Category ID: ABC Classes
Summary: Variables used with return value from Position() are not large enough
The ABC Browse template and classes have a String(1024) declared to hold the return value from Position(). There are circumstances where this is not large enough.
When the templates/classes subsequently try to use a truncated saved position in a call to Reset or Reget an Error 78 is thrown.
Steps to Reproduce:
This is occurring on an SQL based view with several joined tables.
It is currently triggered when used in conjunction with the SortHeader extension/class.
Changing the browse template and classes to have a larger string stops the Error 78 from occuring.
I have marked this as reproducible=always but it does depend on view structure and data withing the view so it is also not always easy to reproduce.
Only tested in Clarion6 but Clarion7-8 have the same template/class string sizes.
Visible to public: Yes
Example App: None submitted