SeedCodeCalendar12

Debugging

SeedCodeCalendar12.Debugging History

Hide minor edits - Show changes to output

February 18, 2013, at 08:18 PM by 98.245.113.231 -
Changed lines 11-12 from:
-> $$sc_iCal and $$sc_iCal_Summary: these are the raw results of Query1 and 2, respectively. If these are missing then there were no events found for the current date range & filters. If either are "?" then there was a problem with the syntax of the SQL queries.
to:
-> $$sc_iCal and $$sc_iCal_Summary: these are the raw results of Query1 and 2, respectively. If these are missing, then there were no events found for the current date range and filters. If the value in either is "?", then there was a problem with the syntax of the SQL queries.
February 18, 2013, at 08:17 PM by 98.245.113.231 -
Changed lines 9-10 from:
-> $$sc_Query1 and $$sc_Query2: the two SQL queries used to find the events that show up in the calendar. in most integrations you change the fields passed INTO these queries (by manipulating the Source XX layouts) and don't change the queries themselves.
to:
-> $$sc_Query1 and $$sc_Query2: the two SQL queries used to find the events that show up in the calendar. in most integrations you change the fields passed INTO these queries (by manipulating the "Source No X" layouts) and don't change the queries themselves.
May 19, 2012, at 11:37 PM by 50.132.84.245 -
Changed lines 5-8 from:
1. Use script debugger. The script debugger in FileMaker Advanced is really essential for following along with scripts as they're executing, you can tell if your script is on the layout you think it is, and importantly, what variables are available to you at any point in a script (via the data viewer).

2. Run the script "Dev ON". This will set a flag preventing the calendar from clearing the (many) variables used to [[Event Variables | parse events]], leaving all this in the data viewer. You'll also be able to see the SQL queries used. The key variables used are:
to:
'''1. Use script debugger.''' The script debugger in FileMaker Advanced is really essential for following along with scripts as they're executing, you can tell if your script is on the layout you think it is, and importantly, what variables are available to you at any point in a script (via the data viewer).

'''2. Run the script "Dev ON".''' This will set a flag preventing the calendar from clearing the (many) variables used to [[Event Variables | parse events]], leaving all this in the data viewer. You'll also be able to see the SQL queries used. The key variables used are:
May 19, 2012, at 11:37 PM by 50.132.84.245 -
Changed lines 7-13 from:
2. Run the script "Dev ON". This will set a flag preventing the calendar from clearing the (many) variables used to [[Event Variables | parse events]], leaving all this in the data viewer. You'll also be able to see the SQL queries used.
to:
2. Run the script "Dev ON". This will set a flag preventing the calendar from clearing the (many) variables used to [[Event Variables | parse events]], leaving all this in the data viewer. You'll also be able to see the SQL queries used. The key variables used are:

-> $$sc_Query1 and $$sc_Query2: the two SQL queries used to find the events that show up in the calendar. in most integrations you change the fields passed INTO these queries (by manipulating the Source XX layouts) and don't change the queries themselves.

-> $$sc_iCal and $$sc_iCal_Summary: these are the raw results of Query1 and 2, respectively. If these are missing then there were no events found for the current date range & filters. If either are "?" then there was a problem with the syntax of the SQL queries.

-> $$sc_Array... the four array variables are the textual representation of the calendar and are the data source for the calendar's display
.
April 16, 2012, at 09:08 AM by 78.86.120.203 -
Added lines 1-7:
!! Any tips for debugging scripts in the calendar?

Everyone has their own debugging techniques but here are a few tips specific to this calendar.

1. Use script debugger. The script debugger in FileMaker Advanced is really essential for following along with scripts as they're executing, you can tell if your script is on the layout you think it is, and importantly, what variables are available to you at any point in a script (via the data viewer).

2. Run the script "Dev ON". This will set a flag preventing the calendar from clearing the (many) variables used to [[Event Variables | parse events]], leaving all this in the data viewer. You'll also be able to see the SQL queries used.
(855) SEEDCODE
[email protected]
Follow us: