Yes. Was assuming that was the case
thanks for complementing it
Yes. Was assuming that was the case
thanks for complementing it
Samuel Pizarro
Hi Harm,
I would like to make cWebList paging results of a big result set of an ESQL query. Actually I populate cWebList that uses ESQL in manual mode. Is there a different way to populate an ESQL cWebList so that she can page the results?
Thank you very much
Luca
Luca,
While I've not tried this I can make a suggestion. If you load the whole result set in OnManualLoadData as you're doing now but instead of sending it straight to the Client you save it in a Server Web property, possibly even paginated, then you can read data from this property and send it to the list a page at a time. Of course, if the data is changing rapidly the stored data could become stale. In this case you might want to reload the property every call which would slow things down a bit.
Ian
The most important leg on a three legged stool is the one that's missing.
Murphy's Law (2)
Luca,
You could make an SQL view from the ESQL statement and then use the SQL view as a ordinary table and make the weblist data aware.
Regards,
Data Access Worldwide
Vincent Oorsprong
I can concur that Vincent’s answer is working great. However I think a reference to a help page or blog is warranted.
Not sure if there is one, other than some slides you might find from a past presentation.
Hopefully daw can add a link.
Marco Kuipers
DataFlex Consultant
28 IT Pty Ltd - DataFlex Specialist Consultancy
DataFlex Channel Partner for Australia and Pacific region
Adelaide, South Australia
www.28it.com.au
this would be the "easiest" and effective approach.
Samuel Pizarro