NetTalk Central

Author Topic: Range limiting - how ?  (Read 2918 times)

Thomas

  • Newbie
  • *
  • Posts: 27
    • View Profile
    • Email
Range limiting - how ?
« on: April 22, 2008, 02:03:07 AM »
In NetWebBrowse Settings - Filters I can have Range limiting. I have done this with "Single value" to a local variable with an initial value. But the browse is empty (ok, there are recs with that value in the table !). Any special settings that I might have overlooked ?

My goal: I habve a table with lots of recs and want to display only a few wich belong to a currently (session) logged in user. The above mentioned local var holds the ID of the logged in user. The next step will be the passing of the ID from the Login page to the WebBrowse.

But at first: how to range limiting a large TPS table to a single value (hte table has an appropriate key) ?
TIA, Thomas

Gregg Matteson

  • Jr. Member
  • **
  • Posts: 59
    • View Profile
    • Custom Program Solutions
Re: Range limiting - how ?
« Reply #1 on: April 24, 2008, 05:15:52 AM »
Thomas.

in your login form - validate update

something like this...

GlobalErrors.Init                !initialize GlobalErrors object
            Access:Client.Init               !initialize Access:Client object

            Access:Client.Open()
            Access:Client.UseFile()
            clear(client)
            Cli:Contact = upper(clip(Loc:Login))
            Cli:Password = upper(clip(Loc:Password))

            Get(Client,CLI:loginKey)
     
                p_web.SetSessionValue('sesspassword',clip(Cli:Password))
                p_web.SetSessionValue('sessgpid',CLI:GroupID)
                p_web.SetSessionValue('sessClico',CLIP(CLI:ClientCompany))
                p_web.SetSessionValue('seeclipuaid',CLI:ClientPUAID)

note their are probably more elegant ways to do this, but it works for me. The point is you are putting record contents into "session" variables so that you can use p_web.GetSessionValue in other procedures. No local variables.  the filtering issue will probably take care of itself after you get this right.

HTH

Gregg
Kindest Regards,

Gregg Matteson

'Software that's actually easy to use'

Thomas

  • Newbie
  • *
  • Posts: 27
    • View Profile
    • Email
Re: Range limiting - how ?
« Reply #2 on: April 27, 2008, 02:37:49 AM »
Hi Gregg,
thanks.... slowly I got the whole picture.
Best regards, Thomas