03-28-2013 08:31 AM
I want to update the longnotes field in the History table, and many of the notes are quite long. I wanted to issue an Execute SQL command, since there are some remotes that also need this update. Therefore, I believe I need to cast the field as varchar(max) within the replace function. I know that varchar(max) is not compatible with the SQL 2000 compatibility level, and have updated the level on the database to 90 (or 100). But still result in a "cannot parse SQL" error. Does anyone know of the SalesLogix OLEDB provider is limited to the compatibility level of 80 (SQL 2000)? I may have to take a different approach.
06-07-2013 06:51 PM
06-09-2013 08:16 AM
Probably.....there are many SQL statements that aren't executeable through the SLX OLE DB Provider....my favorite being TRUNCATE TABLE ACCOUNT
06-09-2013 09:21 AM
07-15-2013 03:34 PM
Thanks Mike! Once again found what I needed with your name attached to it. :-)