I'm trying to make a 'temporal' (spatial) chart which uses day of week as the X Axis, and Time of day as the Y Axis.

Obviously, I don't want a row in that grid for every minute that's possible, but would like to group times in one hour increments.

My idea is to create a field, every time value that meets the selection criterion that would tally a temporary variable for the hour increment it's in.

IE the time (24hour format) reports as 2330 it would add one to the field 'HOUR23'. Time 0330 would tally 'HOUR03', etc..

I've tried a couple of different things :

DEFINE FILE CRIME_INCIDENT_REPORT_HOURLY_TALLIES ADD
HOUR00/A4V=
IF CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME FROM 0 TO 99 THEN 
HOUR00 + 1;
END
 

Or :

DEFINE FILE CRIME_INCIDENT_REPORT_HOURLY_TALLIES ADD
HOUR00/A4V=
IF CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME GE 0000 AND CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME LT 0100
HOUR00 + 1;
END
 

All of the ways that I've tried to do this I end up w/ a (FOC266) IF .. THEN .. ELSE .. SYNTAX ERROR

Without getting into the issues of logic, what am I doing wrong in a syntax sense? I presume I'm actually going to have to incorporate day of week into this situation (Hour00Mon type of situation) also, but I can work on that if I can get over the first syntax hurdle.

Finally, what is the most accessible resource to look at for syntax issues like this? I've looked through many different documentation sources but haven't found anything that's working for me yet.

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

HOUR00/A4V=
IF CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME FROM 0 TO 99 THEN
HOUR00 + 1;

You get an error because of the format of HOUR00. It should be I4 and not A4V.

In my original attempt at this I had it as an I4 value and got the 'Comparison between computational and alpha values....' blah blah.

Short answer : I thought I would get something more descriptive than 'Syntax Error' if it were the format. Changing it over to I4 actually attempted to evaluate the expression so i'm past the syntax issues there.

Thanks Danny!

quote:

DEFINE FILE CRIME_INCIDENT_REPORT_HOURLY_TALLIES ADD
HOUR00/A4V=
IF CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME GE 0000 AND CRIME_INCIDENT_REPORT_HOURLY_TALLIES.ANSWERSET1.FROM_TIME LT 0100
HOUR00 + 1;
END

There is no "THEN" in this expression. Try adding THEN before the HOUR00 + 1 and see what happens.

I ended up using the From / To example, but I think your observation of the missing 'Then' explains part of why I couldn't get the 2nd one to work.

I'll try it that way (with the then added) also. Thanks for the observations, both of you.

In a computational IF ... clause (in a -SET statement), you should always specify the values for both possible conditions (THEN ... ELSE ...).