I'm having an issue adding contacts to my subscription list, through the "Manage Subscription List" wizard. I spent the better part of 7 hours Friday on the phone with tech support. The determination was finally made that my database must be corrupted. After hanging up with support, I tried manipulating my Sync Set (something they had not had me try) I deleted a sync set criteria for a field I had defined that has a date as the field type. The operator was "Within Last (days)" and the value as 30. This apparently was the problem, because now I'm not having issues with the subscription list. The error message I kept getting was "Must declare variable "@NOW". Incorrect syntax near the keyword 'AND' " The support people seemed to have never seen this error message before. Is there anyone with programming knowledge who might understand this? It is very important that I'm able to have a criteria dependent on calendar date.
Thanks for replying. I'm using Act version Version 220.127.116.11, hotbox 1. The version for Act for Palm is 18.104.22.168. This problem is happening prior to sync. It happens when I try and add contacts during Manage subscription List
I get the same message in the demo database as well. Remember, the field that seems to be affecting this, is a field I defined myself. I set up a custom field in the demo (as a date) and it still gave me the error message.