>>SELECT app_activitycomments ; >> FROM appointments ; >> INTO CURSOR c_Temp ; >> WHERE !app_activity AND app_clientfk > 0 AND app_GroupnameFK=0 ; >> UNION ; >> SELECT app_activitycomments ; >> FROM appointments; >> WHERE !app_activity AND app_clientfk=0 ; >> UNION ; >> SELECT app_activitycomments ; >> FROM appointments ; >> WHERE app_activity >>>>
>SELECT app_activitycomments ; > FROM appointments ; > INTO CURSOR c_Temp ; > WHERE ( app_activity ) ; > or ( app_clientfk > 0 AND app_GroupnameFK=0 ) ; > or ( app_clientfk=0 ) > >&& if app_clientfk cannot be negative > >SELECT app_activitycomments ; > FROM appointments ; > INTO CURSOR c_Temp ; > WHERE ( app_activity ) ; > or ( app_clientfk = 0 ) ; > or ( app_GroupnameFK=0 ) > >Hi Gregory,