Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000699 ] Problem creating TableAdapter with WHERE parameter

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000699 ] Problem creating TableAdapter with WHERE parameter
Date: 2006-08-07 21:32:35
Message-ID: 20060807213235.940B886C6A5@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000699, was opened at 2006-08-04 23:51
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000699&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Adriano Bonat (adrianob)
Assigned to: Nobody (None)
Summary: Problem creating TableAdapter with WHERE parameter

Initial Comment:
I'm having problem when creating a TableAdapter (via TableAdapter Wizard), I build a query using Query Builder like this:

SELECT     id, name
FROM         "public".cc_projects
WHERE     (id = ?)

executing the query runs fine, asking me the value of '?' and returning the selected data. I continue the process leaving 'Fill' and 'return DataTable' marked, when the wizard start to generate the code, it throws this error:

The wizard detected the following problems when configuring the TableAdapter: "Fill":
Details:
Generated SELECT statement.
	ERROR [42601] ERROR: syntax error at or near ")";
	Error while executing the query

If I put a fixed value in the query, like 'id=1' it works fine.

Follow attached a zipped file with 2 log files that could help you, any other information that you need, just ask me.

Thanks.

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-08-07 21:32

Message:
Could you try the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?
Or please try to turn on the UseServerSidePrepare option.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000699&group_id=1000125

pgsql-odbc by date

Next:From: Biswajit BardalaiDate: 2006-08-08 21:19:39
Subject: ODBC connection string
Previous:From: Relyea, MikeDate: 2006-08-07 19:40:55
Subject: Re: Slow transfer speeds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group