Ajax Calendar with Visual Foxpro and jQuery

Per a request and for a little bit of fun, I created a flat ajax calendar with jQuery and Visual Foxpro for use with the Web Connection framework. This demo allows you to load a calendar and it’s navigation via ajax and edit events without time consuming page reloads.

You can add an event to each day by clicking the small ‘edit’ button next to the day number. I haven’t included anything like security, users, authentication, etc. but I think it is flexible enough too. This comes straight out of my intranet app, so may be a little rough around the edges as I had to generalize it for demo purposes.

Update (08/06/2008): Fixed the download link. Oops.

Download Zip

There is no live demo, as I don’t have a public facing Windows server to put it on. Sorry.

Tested on the following browsers
IE6 on Windows XP (works)
IE7 on Vista (works)
FF2 on Vista and XP (works)
Opera 9 on Vista (works)
Safari on Vista (kinda works, probably fixable)

Written in
VFP 7 and West Wind Web Connection 4.68


Flat Calendar Screenshot 1

Flat Calendar Screenshot 1

Flat Calendar Screenshot 2

Flat Calendar Screenshot 2

Install Instructions
I’m sure you all know how to do this, but just in case. If I miss a step here, please let me know.

  1. Download the zip file and unzip to a temp directory
  2. Open the folder of the freshly unzipped file. You should see two folders, vfp and www
  3. The ‘www’ folder contains a folder called ‘FlatCal’. Place this folder in the root of your IIS install or create a virtual directory in IIS to this folder. Make sure that you have ‘index.html’ as a default document option.
  4. Create a scriptmap of ‘.fc’ to the wc.dll in IIS that is accessable from either the wwwroot or the virtual
  5. Open the folder called ‘vfp’
  6. Place the three files for the ‘flatcal_events’ free-table in your data directory where it is accessible from your wconnect app
  7. Place the two prg files in your programs directory where you can add them to your wconnect project
  8. Add the ‘FC’ scriptmap extension to the main file in your wconnect app
  9. Add this code ‘Set Procedure To flatcal_main Additive’ in the ‘SetServerProperties’ function in the main file in your wconnect app
  10. Open your browser and point it towards ‘http://localhost/FlatCal/’

Credits go to

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.