Community
Showing results for 
Search instead for 
Do you mean 
Reply

Incorrect syntax near 'B'

New Member
Posts: 3
Country: Australia

Incorrect syntax near 'B'

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

 

Kind Regards

 

Bronwyn Clarke

ACT! Consultant - Sydney Australia

bronwyn@eyecatchers.net.au

Copper Elite Contributor
Posts: 108
Country: United States

Re: Incorrect syntax near 'B'

Bronwyn,

 

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.

 

MrWright

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Incorrect syntax near 'B'

Database repair in ACT! has fixed this for the users I have seen with this issue