NetTalk Central

Author Topic: Browse Filter - getting the table record ID field  (Read 1847 times)

David

  • Full Member
  • ***
  • Posts: 127
    • View Profile
Browse Filter - getting the table record ID field
« on: February 16, 2015, 05:53:27 PM »
I have a browse on a department table and I want to filter based on the DEP:RecordID field.  In the template filter field I have tried DEP:RecordID and p_web.GSV('DEP:RecordID') both return blank data.  I have looked at the actual table and the DEP:RecordID field has data in it.

How do I get the data in that field?

Thank you,
David

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Browse Filter - getting the table record ID field
« Reply #1 on: February 16, 2015, 08:08:36 PM »
HI David
 try

'DEP:RecordID = ' & p_web.GSV('DEP:RecordID')

if DEP:recordID is numeric or

'DEP:RecordID = <39>' & p_web.GSV('DEP:RecordID') & '<39>'

If it is a string

[Edited to make it a bit easier to read - Bruce]
« Last Edit: February 17, 2015, 03:20:04 AM by Bruce »
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186