Skip to Content
0
Former Member
Mar 26, 2009 at 07:05 AM

problem in retriving data in query of user defined table(Document)

21 Views

hi,

am retriving data from two tables(RDR1,@DOCUMNET) by making joins

when i am giving conditions in where clause of @DOCUMENT am got the below error

BUT without any conditons in where clause all data is retriving from tables

"This entry already exists in the following tables 'Service Contracts' (OCTR) (ODBC -2035) [Message 131-183]"

example:

" select * FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry LEFT JOIN [dbo].[@DOCUMENT] T2 ON T1.DocEntry=T2.U_DocEntry AND

T1.LineNum=T2.U_LineNum

WHERE T0.[DocNum]=[%0]

AND T1.[Dscription]='[%1]'"