Bindvariables in from-clause connecting to sql server by ole db

comp.databases.gupta (1995-2015)
tinke...

Bindvariables in from-clause connecting to sql server by ole db

Post by tinke... » 15 May 2005, 11:34

 Posted by:  tinke...@hotmail.com 

I have the following problem. I get an error on the prepare of this
statement.

SELECT OMS.sOmschrijving, TAAL.sTaal
FROM (TAAL LEFT OUTER JOIN OMS ON OMS.nTaalUN = TAAL.nUN AND
OMS.nParentUN = :pnParentUN)

When I use odbc it al works fine, but when I use ole db I get an error
on the variable in the from-clause. When I replace this variable by
it's value it also works fine.

Does anybody have any idea what I'm doing wrong?

Thanks

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot], [Semrush] and 0 guests