ZOHO ODBC with SSMS - Column names with spaces
Posted: Fri 21 Apr 2017 01:48
Hi,
I'm using a linked server in SSMS to Zoho. How do I insert a row in a table with columns that have spaces in them?
I tried these:
I got error: Zoho CRM]Access violation at address 000000000063ADE7 in module 'DevartODBCZoho.dll'. Write of address 0000000000000094
I got error: Unknown column '[Solution Title]
I got error: Unexpected symbol ':'
I got error: List index out of bounds (0)
Thank you.
I'm using a linked server in SSMS to Zoho. How do I insert a row in a table with columns that have spaces in them?
I tried these:
Code: Select all
INSERT ZOHO...[Solutions] ([Solution Title]) VALUES ('TEST1')
Code: Select all
INSERT OPENQUERY (ZOHO, 'SELECT [Solution Title] FROM Solutions') VALUES ('TEST1')
Code: Select all
INSERT OPENQUERY (ZOHO, 'SELECT "Solution Title" FROM Solutions') VALUES ('TEST1')
Code: Select all
INSERT OPENQUERY (ZOHO, 'SELECT ''Solution Title'' FROM Solutions') VALUES ('TEST1')
Thank you.