Got a small problem .. Trying to write a query over a UDO , code shown below ..
string copiedFrom = "99" ; // Just a sample .. string queryString = "Select * from @My_File where DocEntry = " + copiedFrom; rsCopiedFrom.DoQuery(queryString);
The DoQuery throws an exception -
+ $exception {"1). [Microsoft][SQL Native Client][SQL Server]Must declare the table variable \"@My_File\".\n2). [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.\n"} System.Exception {System.Runtime.InteropServices.COMException}
Anyone shed any light ?