Update current record when click on View

[faraz]

When i click on View, i need the current record should populate with current date/time. But following is not working:
ServerEvents->TableSpecific->ViewPage->Page_Load
ExecuteScalar("update first_status_changed set converted = NOW()
WHERE customer_id = '" . $rsold['customer_id']. "' ");

facing following error:
Notice: Undefined variable: rsold in C:\xampp\htdocs\mip2019\classes\submissions_view.php on line 1790
Notice: Undefined variable: rsold in C:\xampp\htdocs\mip2019\classes\submissions_view.php on line 1793

please suggest any idea.

[sticcino]

there is no $rsold in a view.

[faraz]

Then what should be used instead ?

Please help.

[sticcino]

$this->FIELD_NAME->CurrentValue;

review the generated code.

[faraz]

echo $this->customer_id->CurrentValue;

The above showing no value when echo on View page.

[mobhar]

Put that code in Page_Render server event instead.