Problem with Header sort on fields from related records

[terryd]

Clarion 9056 XP Professional Nettalk 4 PR 28 MSSQL backend IE6 browser
If I have any fields in a browse populated by looking up a parent record the correct information from the parent displays against each record.
However if I click the header to sort based on that field the browse clears and the message 'No records found' appears. This only affects fields from parent files, sorting on fields on the Primary.browse file sort normally. This behaviour occurred on previous version but I waited until 28 in case it cleared up.
Clicking the menu choice to re-display the browse has no effect, neither does starting a new instance of the web browser. The only way I can restore the original browse is to stop the webserver and restart it.
Is there any workaround. At the moment I am setting no sort on each field but since they are key fields they are normally fields that I need to sort on.
Attached images: err1.tif - normal browse err2.tif - after sort on field Insured name (local field) err3.tif - after sort on Master (field in a lookup table )
Thanks
Terry Davidson
         

[attachment deleted by admin]

[Bruce]

Hi Terry,

A quick test (with FF and TPS) doesn't show the same problem, so I assume it's related to MsSql.
I'll run a test against the MsSql server when I get in the office.

Do you mention IE6 because that's what you're using - or because it's the only one failing? I don't think the browser will be affected in this situation.

Cheers
Bruce

[terryd]

Thanks
No I only mentioned IE6 in case there was an issue with it. I have unloaded my Firefox until they sort out the garbled print issue.
Terry Davidson

[peterH]

Was there ever any solution to this? I'm facing the same problem as Terry.

Peter

[peterH]

In case someone else is struggling with this I found the solution: you must define a relation in the dict if you want to be able to click-sort on a column with a lookup field. Easy once you know 

Peter