NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: oggy on February 18, 2014, 12:28:45 AM

Title: Reminder: how to get row id?
Post by: oggy on February 18, 2014, 12:28:45 AM

I need quick reminder, because of ages ;)
How to get browse row id to pass value to, for example, printing?
Regards, Ozren.

Title: Re: Reminder: how to get row id?
Post by: rjmiller on February 18, 2014, 07:12:34 AM

I am sure there are many ways to do this.  The way I have done it is pass the value of a unique id such as what is used in primary key.  I am also well into my forgetting years.  Between age and not keeping at it full time it gets hard to stay on top of things.

Good luck.

  RJ

Title: Re: Reminder: how to get row id?
Post by: oggy on February 18, 2014, 07:38:51 AM

hm, in NT5 my code to do that is like: p_web.GetValue('id'). But, in recetly purchased NT7 this not working?

Title: Re: Reminder: how to get row id?
Post by: rjmiller on February 18, 2014, 09:05:40 AM

I have not gotten to that point in current (NT 7.34) application.

I did it differently in NT6 (probably the hard way).  I either called a memory for for input and then set session values.  Then in my CPCS report I set report filter based on get of session values.  For a single record you could set the session value to a unique value for record in embed of inline button on browse and then filter on that in report.

  RJ

Title: Re: Reminder: how to get row id?
Post by: debzidoodle on February 18, 2014, 12:09:18 PM

Use GetSessionValue... p_web.gsv('<Your PK Column name>')

Title: Re: Reminder: how to get row id?
Post by: Bruce on February 18, 2014, 07:41:01 PM

make sure the button on the browse has "include row id" ticked on.

cheers
Bruce

Title: Re: Reminder: how to get row id?
Post by: oggy on February 18, 2014, 10:58:30 PM

Try it, and work, but I noticed one thing, when I use primary key the whole thing didn't work, with other key(s) works well...
Regards, Ozren.