10-02-2008 02:40 PM
ACT 9 Premium
When creating Subgroups the dialog box appears with this error Incorrect syntax near 'B'
I have seen some earlier posts re this error and Database Repair was suggested but not indication of this fixing was mentioned
If anyone has had this experience or has a confirmed solution would greatly appreciate any ideas - unable to locate any other solutions to date in KB
ACT! Consultant - Sydney Australia
10-03-2008 04:52 PM
After searching, I was unable to locate an exact answer, but I was able to discern that it has everything to do with your database and SQL. I recommend the database repair. If this does not correct the problem, then I would trying working the the ACT11Demo database to see if the problem manifests. If it does, then I would suggest removing and reinstalling Act! using the Actunisntaller. If it doesn't, then it is a database repair issue.
Hope this helps.
10-04-2008 04:56 AM