NetWebServiceMethod - PROP:SQLFilter

[Thys]

Hi,

I have problem to get the sort order correct of a response view (SQL) whenever the SQL filter is set.

I have a clause in the "Order By" field, typically a name column. When the "SQL Filter" value is empty, the response is sorted correctly. But when I add an SQL filter clause, the ordering in the response returns to the default order and not that which is in the "Order By" field. I can't do without the SQL Filter value because Clarion syntax does not address NULL values properly.

These two have seemingly nothing in common - filtering should not affect ordering. But I've found that it does. As there a solution to this please?

Thys

[Alberto]

Did you try using PROP:SQLorder ?

[Thys]

Yes, no difference. Whatever is in PROP:SQLOrder or PROP:Order gets negated in the JSON.Append method, whenever PROP:SQLFilter is set.

[Bruce]

I think I'd need to see some sample code to see what you are doing Thys...