i.e.
Select field1, field2
from table
for fetch only with ur;
When I enter this into the query wizard and then move off the SQL pane to another pane, the wizard quotes the sql so it looks like so:
Select field1, field2
from table
FOR "fetch" "only" "with" ur;
Hence my predicament. When I try to run this or press the ok button to save the query, it won't run because the odbc driver isn't expecting fetch, only, and with to be in double quotes. Is this a known issue or is there some key token to indicate that the keywords should be left alone.
In case anyone is wondering why this would be a problem, in DB2 the keywords above indicate to not use record locking on a table. In an enterprise situation with potentially thousands of users, record locking is not acceptable. In order for our enterprise to use the new enhancements made in VS 2005 to the tableadapter, we need a way around what the designer is doing.
Please advise.To the moderator of this forum:
This post was moved from the C# IDE forum by someone who didn't understand what I was asking them. I've reposted it with clearer meaning (hopefully). Please remove this post from this forum. It doesn't belong here. I would delete it if I could, but I don't seem to have the button to do it anymore.
Thanks,
Jonsql
No comments:
Post a Comment