where do I put prop:sql to speed up my select?

[pcrafton]

Where would I put a Prop:Sql SELECT statement in the WebBrowse for record retrieval? If I am not mistaken that would speed up retrieval of my browse records. SQL seem to run fairly slow if I use Prop:filter.

Regards

Paul Crafton
PTS Solutions

[Bruce]

Hi Paul,

What does your filter look like? The most common cause of slow browses is incorrect filter statements.

Also, since the browse is based on a VIEW (just like a normal Clarion browse) it would seem to me that you're better off using Prop:SqlFilter over Prop:Sql. Or better yet the SQL() funtion. See normal Clarion docs for more help on SQL().

In terms of placement - right click on the browse procedure and search for LOOP. This is the start of the browse loop, and you'll see code (and embed points) right before it where the filter can be set.

Cheers
Bruce

[pcrafton]

Bruce:

as per normal you are a genius with the quick reply.

Paul