NetTalk Central

Author Topic: Use assigned fields with entry lookup  (Read 4225 times)

JohanR

  • Sr. Member
  • ****
  • Posts: 375
    • View Profile
    • Email
Use assigned fields with entry lookup
« on: October 07, 2018, 12:43:53 AM »
Hi,

  In the server embed I need to use some of the values in the extra assigned fields, but they are only being assigned after this embed as per code below.
  I can make a plan here , but just wanted to know what the correct way would to this ?

TIA for any assistance

Johan

  do ValidateValue::loc:fc_super_field  ! copies value to session value if valid.
  ! Start of "After Validate New Value"
  ! [Priority 4000]
 
      need to use the assigned fields here to do some other clever stuff
 
  ! End of "After Validate New Value"

  p_Web.SetValue('lookupfield','loc:fc_super_field')
  do AfterLookup   <<<*******<<<<<<        but it seems as if the other assigned fields are only moved accross in the AfterLookup routine








DonRidley

  • Don Ridley
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • donaldridley2011@gmail.com
    • View Profile
    • Email
Re: Use assigned fields with entry lookup
« Reply #1 on: October 07, 2018, 01:33:21 AM »
I don't

Bruce talked about something similar during a user group webinar a while back.

It's early here and I'm going by memory so....

I think you'll have to Fetch the record you need after the lookup.

SomeKeyFieldValue = MyKeyFieldValue
Access:SomeTable.Fetch(SomeKey)
p_web.SSV('OtherField', OtherField)


I left out level:benign for brevity but you get the idea.

Something like that.

Good luck,

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

NetTalk 12.55
Clarion 11