nadler Super User 
          
 
  Joined: February 25 2006 Location: United States
 Online Status: Offline Posts: 354
          | 
        
         
          
           | Posted: December 21 2006 at 11:05 | IP Logged
		     | 
                    
            		  
           | 
           
          
           
  | 
           
          
This simple macro is called by other macros.  It checks to see if the time is between 6 am and 8 am.  If so it says "Good morning" and runs the Get Weather macro which announces the complete weather.
 
 insert into macroheader values ('TESTING BETWEEN TIMES','TEST',0,1,1);
 insert into macrodetail values ('TESTING BETWEEN TIMES',1,37,'',NULL,'Called from other macros, this macro tests between 2 different hours',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',2,16,'',NULL,'If(hour(now())>5,1,999)
 ',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',3,16,'',NULL,'if (hour(now())<9,1,999)',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',4,9,'',NULL,'"Good Morning"',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',5,1,'GET WEATHER',1,'',0,'');
 insert into macroheader values ('TESTING BETWEEN TIMES','TEST',0,1,1);
 insert into macrodetail values ('TESTING BETWEEN TIMES',1,37,'',NULL,'Called from other macros, this macro tests between 2 different hours',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',2,16,'',NULL,'If(hour(now())>5,1,999)
 ',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',3,16,'',NULL,'if (hour(now())<9,1,999)',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',4,9,'',NULL,'"Good Morning"',0,'');
 insert into macrodetail values ('TESTING BETWEEN TIMES',5,1,'GET WEATHER',1,'',0,'');
 
         |