Search options (Page 13 of 14)

How To edit script when DateTimePicker  On_Change and display in lable or textbox

sample
A = Start Date (01/01/2015)
B = Stop Date (25/06/2015)
Answer
B - A
Display = " Year=0 Month=5 Day=24 "

How to edit Script  ?
My Student  Ark me  but I Haven't Answer because function this can apply birth ,expire date or etc
help me please !
Download My Project
09 Lesson Script.zip

Sample Screen Shot

I Have  2 Form
1- frm_a (start from)
   - Button(open from b)
2- frm_b

how to edit script when click button open frm_b  and  close frm_a

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 ?

In Group  Footer  It Display  Logic Error
I will to display
Sum (-3600 ,-3600) = -7200

But Report display = -3600-3600
How to edit  in System memo or Where ?

how to set or edit
tablegrid 1 = master
tablegrid 2 = detail

on even onclick 

help me please !

Download Project Below This

lesson 009 mater detail.zip

will to use teach my student in classroom System development Life Circle

what is Dialog Page In report design  ?
how to edit or input parameter date time ,string  or integer in dialog page ?