NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: britech on July 29, 2010, 04:13:54 PM

Title: DropList Filter not working properly. Suggestions ?
Post by: britech on July 29, 2010, 04:13:54 PM

Hi Folks,

I have a field on a form, where I have a DropList that needs to be filtered.

'CHA:ClientID=5'      THIS WORKS! in the filter.

'CHA:ClientID=LOC:Client_ID'     DOES NOT work.

I know that LOC:CLIENT_ID=5  , because I have messaged it at these 3 embed Points:

GenerateForm / Start

Generate Form / Before Form

InitForm / Start

LOC:Client_ID = 5  at all three locations in the code.
I have added LOC:Client_ID as a hot field, I have added CHA:ClientID as a hot field.
Nothing seems to work.

Suggestions?

Brian

Title: Re: DropList Filter not working properly. Suggestions ?
Post by: kevin plummer on July 29, 2010, 04:29:54 PM

try

'CHA:ClientID=' & LOC:Client_ID

Title: Re: DropList Filter not working properly. Suggestions ?
Post by: britech on July 29, 2010, 05:10:05 PM

Perfect !!!!!
Forgot this was being thrown into a PROP:SQL statement, which knows nothing about LOC:CLIENT_ID.
Good eye Kevin, and thanks.

Brian

Title: Re: DropList Filter not working properly. Suggestions ?
Post by: Robert Iliuta on August 30, 2010, 11:39:37 PM

Thank you tooo Kevin!
Didn't know why was not working....
Robert