table1:
LET start=Today(); //Current Date
LET end=Today(); //Current Date
SQL SelectRegistrationStatisticsByDate '$(start)' , '$(end)';
Let day1 = peek('RegistrationStatus',0,'table1');
Let day2 = peek('RegistrationStatus',1,'table1');
Let day3 = peek('RegistrationCount',0,'table1');
Let day4 = peek('RegistrationCount',1,'table1');
SQL INSERT INTO tbl_Kiosk_Statistics VALUES($(day4),$(day3));
LET start=Today(); //Current Date
LET end=Today(); //Current Date
SQL SelectRegistrationStatisticsByDate '$(start)' , '$(end)';
Let day1 = peek('RegistrationStatus',0,'table1');
Let day2 = peek('RegistrationStatus',1,'table1');
Let day3 = peek('RegistrationCount',0,'table1');
Let day4 = peek('RegistrationCount',1,'table1');
SQL INSERT INTO tbl_Kiosk_Statistics VALUES($(day4),$(day3));
No comments:
Post a Comment