Link on browse field not working as expected.

[astahl]

Hi Bruce,

I have a table field on a browse which I set to "On click" the URL to call a procedure that uses the field value to filter another browse.

In the Embed "User clicked on a row in the browse" I have this code

  DO OpenFiles
  CLEAR(bat:Record)
  bat:id = p_web.GetValue('bat:id')
  IF NOT Access:etc_batchaudit.Fetch(bat:PRIMARY) THEN
    p_web.SetSessionValue('mybatch',bat:batchrecnum)
  END
  DO CloseFiles

If the user clicks on the link field then the browse fetches the last record that was previously select. If user clicks on the row and then the link field the data is fetched correctly.

Where should the above code be placed to make this work?


Ashley

[kevin plummer]

Hi Ashley,

onclick and server side code won't work together. You would need to more your source into the procedure you are calling via on-click. The other option is to use Javascript after your SS code to open the next window instead of Onclick

[astahl]

Hi Kevin,

Suspected that was the case when it was not working.

Thanks Kevin.

Ashley