NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Rhys Daniell on July 23, 2007, 09:05:40 PM

Title: Prop:SQLFilter
Post by: Rhys Daniell on July 23, 2007, 09:05:40 PM

One for Bruce I suspect.

Is there/can we have an embed or template selection which would allow Prop:SQLFilter to be used in place of Prop:Filter?

Title: Re: Prop:SQLFilter
Post by: Bruce on August 01, 2007, 12:47:42 AM

Hi Rhys,

There's an embed point in the browse called "Browse Filter".
This happens after the filter is "constructed".
So this is probably the best place to use prop:SqlFilter.

Be aware though that the locator functionality makes use of the filter (and alters it) in the SetView statement. So the + form of the SQL filter is probably gonna work the best for you.

Of course a better approach is to use the SQL () statement inside the regular filter. This would then have the minimum number of side effects.

Cheers
Bruce

Title: Re: Prop:SQLFilter
Post by: Rhys Daniell on August 01, 2007, 04:44:44 PM

> SQL()
Good grief! There's a page in the Clarion help system I haven't read yet.

Thanks, Bruce!