Hi Nettalk people!
In a NetWebBrowse on a SQL table that's supposed to display a record, it first comes up with a 'no TableA records' message. Upon pressing Refresh (F5), the NetWebBrowse displays the correct record.
I enabled trace and found that the difference between the first SQL statement (which does not show the record) and the next one (which shows the record) is this:
The first statement has this tacked onto the end of the WHERE clause:
AND ( A.GUID >= ? )
The second statement doesn't have this 'A.GUID >= ?' part.
Question: How can I determine the value of ? in the trace.
And, why is the record not fetched on the first instance but fetched on F5 (refresh) ?
edit: In another instance where it is supposed to show five records, it shows only four on the first instance and upon refresh shows all the five records. A trace showed the same difference between the two SQL statements as above.