NetTalk Central

Author Topic: Need help with update form...  (Read 5141 times)

DonRidley

  • Don Ridley
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • donaldridley2011@gmail.com
    • View Profile
    • Email
Need help with update form...
« on: July 29, 2009, 10:13:35 AM »
This is frustrating the crap out of me.   I know it's something simple but I cannot - for the life of me - firgure it out.   I've went back and forth from the examples and the docs and I just can't get it.   

Okay...

I have a update form.  On that page I have a child browse.  When I try to enter a record into the child browse, the field that relates the child to the parent is not being primed properly.   I tried:

Under Priming in the Update Form
PHO:RecordNumber = p_web.GetValue('HOT:RecordNumber') but that is not working.

Parent Table is: HotSheet
Parent Key:  :    HOTKeyRecordNumber

Child Table is: Photos
Foreign Key:     PHO:KeyRecordNumber

It is one-to-many.

I don't know folks what I'm doing wrong.....

Don
"Eliminate the impossible, whatever remains, however unlikely, must be the truth."

NetTalk 12.55
Clarion 11

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Need help with update form...
« Reply #1 on: July 29, 2009, 06:57:03 PM »
Try

PHO:RecordNumber = p_web.GSV('HOT:RecordNumber')

When stuff like this is not working for me I put a debug message in for

p_web.GetValue('HOT:RecordNumber')
and
p_web.GSV('HOT:RecordNumber')

to see what value they both return

DonRidley

  • Don Ridley
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • donaldridley2011@gmail.com
    • View Profile
    • Email
Re: Need help with update form...
« Reply #2 on: July 29, 2009, 08:23:30 PM »
Thank you Kevin.   I'll try that out as soon as I get to my development machine.   

Don
"Eliminate the impossible, whatever remains, however unlikely, must be the truth."

NetTalk 12.55
Clarion 11

DonRidley

  • Don Ridley
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • donaldridley2011@gmail.com
    • View Profile
    • Email
Re: Need help with update form...
« Reply #3 on: July 31, 2009, 07:31:33 AM »
Hey Kevin, worked like a charm!  Thank you.
"Eliminate the impossible, whatever remains, however unlikely, must be the truth."

NetTalk 12.55
Clarion 11

Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Need help with update form...
« Reply #4 on: July 31, 2009, 11:33:30 PM »
Hi Don,
When data base fields are involved, ALLWAYS use GSV!!!
GetValue is for parameters only.
Rene
Rene Simons
NT14.14

DonRidley

  • Don Ridley
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • donaldridley2011@gmail.com
    • View Profile
    • Email
Re: Need help with update form...
« Reply #5 on: August 01, 2009, 04:37:49 PM »
Hello Rene,

Thank you.   Still going uphill on the Web Server learning curve  ;D .
"Eliminate the impossible, whatever remains, however unlikely, must be the truth."

NetTalk 12.55
Clarion 11