Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQLSTATE = 37000 (microsoft odbc....
814 views
Skip to first unread message
JEY_AR
Jul 9, 2003, 1:11:14 PM7/9/03
to
I'm worrking wit 7.0.3 build 10047, Sql Server 2000 and Windows2000 Prof.
In a dataobject I've the following select:
In a dataobject I've the following select:
SELECT r.rec
FROM r
WHERE exists
(SELECT *
FROM u
WHERE ( u.id = :arg_id ) AND
( u.rec = r.rec ) )
Whe I retrieve the datawindow I recieve the following error:
SELECT ERROR: SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver]Sintax Error or access infraction.
How can I fix this?
Thanks,
JA
Jim O'Neil [Sybase]
Jul 10, 2003, 11:39:46 AM7/10/03
to
I think it's the use of the argment in the subselect. Try setting
DisableBind=1 as a workaround.
DisableBind=1 as a workaround.
Jim O'Neil
Principal Technical Support Engineer
Sybase, Inc.
Concord, MA
Matthew Chestnut
Jul 10, 2003, 8:56:42 AM7/10/03
to
From what I can recall, this error is caused using Microsoft ODBC with
retrieval arguments in a sub-query (your WHERE EXISTS ...).
retrieval arguments in a sub-query (your WHERE EXISTS ...).
I don't know who is at fault, Microsoft or PowerBuilder, but one
workaround is to set DisableBind = 1 in your sqlca.dbparm.
On Wed, 9 Jul 2003 13:11:14 -0400, JEY_AR wrote:
0 new messages