statusid statusdesc isactive -------------------------------------------------- 1 enter room 1 2 exit room 1 3 arrive 1 4 depart 1The second table contains status by meetingnumber. The user would click on a status to assign it to a meeting it's called ctPatStatus
patstatusid meetingnumber statusid statustime --------------------------------------------------------- 1 1 1 02/10/2002 17:00 1 1 2 02/10/2002 18:00What I want to be able to do is create a cursor that I can present to the user that displays all the available events, and beside the events that have a datetime show that, otherwise show a null.
enter room 02/10/2002 17:00 exit room 02/10/2002 18:00 arrive NULL depart NULLThe following this the vfp code I have tried:
SELECT dbo.costatus.statusid,dbo.coStatus.statusdesc, dbo.coPatStatus.statustime FROM dbo.coStatus LEFT OUTER JOIN dbo.coPatStatus ON dbo.coStatus.statusid = dbo.coPatStatus.statusid WHERE coPatStatus.meetingnumber=?gnMeetIDBut I get no results once I put the where clause. If I leave the where cluase off, I all the events and matching ctPatStatus records, but not limited to the ones I need.