Hi,
I have a trouble when i execute this query with sapbobscom.recordset (The query is ok on HANA Designer).
What is wrong ? Is Recordset support SEMICOLON ?
The error message is 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near ";": line 4 col
My Test Query
create Local temporary table #Table ( TRANSPCODE nvarchar(15) , TRANSPNAME nvarchar(100) ); INSERT INTO #Table (TRANSPCODE, TRANSPNAME) SELECT T0."CardCode", T0."CardName" FROM "SBO_TEST".OCRD T0 where T0."GroupCode" = 101; select * from #Table; drop table #Table;
Kinds Regards