NetTalk Central

Author Topic: Reminder: how to get row id?  (Read 4801 times)

oggy

  • Full Member
  • ***
  • Posts: 219
    • View Profile
    • Email
Reminder: how to get row id?
« 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.

rjmiller

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • Email
Re: Reminder: how to get row id?
« Reply #1 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

oggy

  • Full Member
  • ***
  • Posts: 219
    • View Profile
    • Email
Re: Reminder: how to get row id?
« Reply #2 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?

rjmiller

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • Email
Re: Reminder: how to get row id?
« Reply #3 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

debzidoodle

  • Jr. Member
  • **
  • Posts: 98
    • View Profile
    • Email
Re: Reminder: how to get row id?
« Reply #4 on: February 18, 2014, 12:09:18 PM »
Use GetSessionValue... p_web.gsv('<Your PK Column name>')


Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Reminder: how to get row id?
« Reply #5 on: February 18, 2014, 07:41:01 PM »
make sure the button on the browse has "include row id" ticked on.

cheers
Bruce

oggy

  • Full Member
  • ***
  • Posts: 219
    • View Profile
    • Email
Re: Reminder: how to get row id?
« Reply #6 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.