Topic: Script Not Action In Click Button Event
i set button when click run sql:update table
but after no action to display
procedure frm_item_Button2_OnClick (Sender: string; var Cancel: boolean);
begin
SQLExecute(
'update alldata '+
'set tm_group = '+
'case '+
'WHEN substr(dateservice,6,2) ="01" then "jan" '+
'WHEN substr(dateservice,6,2) ="02" then "feb" '+
'WHEN substr(dateservice,6,2) ="03" then "mar" '+
'WHEN substr(dateservice,6,2) ="04" then "apr" '+
'WHEN substr(dateservice,6,2) ="05" then "may" '+
'WHEN substr(dateservice,6,2) ="06" then "jun" '+
'WHEN substr(dateservice,6,2) ="07" then "jul" '+
'WHEN substr(dateservice,6,2) ="08" then "aug" '+
'WHEN substr(dateservice,6,2) ="09" then "sep" '+
'WHEN substr(dateservice,6,2) ="10" then "oct" '+
'WHEN substr(dateservice,6,2) ="11" then "nov" '+
'WHEN substr(dateservice,6,2) ="12" then "dec" '+
' end ;'
);
end.
My Project
jintana.zip
Help me please ?
Easy For Beginner Student For Me