I am having trouble updating and inserting records into a progress database from SQL where the table name contains a hyphen. I have the same problem using linked server and DTS packages.
I can insert and update columns that have hyphens as long as the table name does NOT have hyphens.
I can select data fine with table names that have hyphens - here is an example of a query that works:
select * from openquery(Syteline_test, 'select uf\-support\-class from ux\-item where item = ''00011''')
However when I try to update this same field I get an error message. Here is the query:
update openquery(Syteline_TEST, 'select uf\-support\-class from ux\-item where item = ''00011''') set [uf-support-class] = 2
Here is the error message:
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure
[OLE/DB provider returned message: Query cannot be updated because the FROM clause is not a single simple table name.]
I have tried qualifying the table name and that also does not work.
Any Thoughts?
Thanks.
I can insert and update columns that have hyphens as long as the table name does NOT have hyphens.
I can select data fine with table names that have hyphens - here is an example of a query that works:
select * from openquery(Syteline_test, 'select uf\-support\-class from ux\-item where item = ''00011''')
However when I try to update this same field I get an error message. Here is the query:
update openquery(Syteline_TEST, 'select uf\-support\-class from ux\-item where item = ''00011''') set [uf-support-class] = 2
Here is the error message:
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure
[OLE/DB provider returned message: Query cannot be updated because the FROM clause is not a single simple table name.]
I have tried qualifying the table name and that also does not work.
Any Thoughts?
Thanks.