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: Closed
Resolution: None
Priority: 3
Submitted By: Adriano Bonat (adrianob)
>Assigned to: Hiroshi Inoue (hinoue)
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: Adriano Bonat (adrianob)
Date: 2006-08-08 05:15
Message:
Using the same ODBC driver and turn on 'Server side prepare'
didn't work. But with your version it's working fine.
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