Was wondering if there is some setting in VS2005 where it can build my sql
commands using that postgresql quote instead of brackets.
Createing a SqlDataSource and using this bible reference:
http://www.123aspx.com/redir.aspx?res=35840
I checked the "Generate INSERT, UPDATE dn DELETE statements from my SELECT
sql code: SELECT * from "Users"
the " is needed as there is mixed case in postgresql
OK - VS2005 generated the following code that is close but does not win the
prize:
====as generate by gatesware====
UPDATE [Users] SET [lastLogin] = ?, [administrator] = ?, [files_path_prefix]
= ? WHERE [id] = ? AND [authString] = ? AND [realName] = ?
=====end of was generated for me, thanks====
Problem 1.
I need to go in and replace each and every [ and ] with "
This is certainly do-able but I got a lot of code to write. Is there
some customization setting in VS2005 where I can re-define those sql
delimiters or whatever they are called? Maybe if we had bought MS SQL this
would not be a problem?
Problem 2
The WHERE is misplaced. I made everything readonly except
realName as that is all that is allowed to be changed. Again, I
can mod the code from the above auto-generated to ...
UPDATE "Users" SET "realName" = ? where "id" = ?
WILL THIS EVEN WORK?
I am a newbie on using gridview on web pages, I got the EDIT button to
work and after making my changes I click on UPDATE and discovered that I was
supposed to have generated the update command during design mode. Sooo ...
is gridview smart enough to see UPDATE "Users" SET "realName"=? where "id"=?
and substitute the correct field info into the ? before executing the query?

Signature
======================================================================
Joseph "Beemer Biker" Stateson
http://TipsForTheComputingImpaired.com
http://ResearchRiders.org Ask about my 99'R1100RT
======================================================================
Beemer Biker - 28 Apr 2007 15:28 GMT
This is a known bug. Unfortunately, it was "closed" by micro$haft in 2006
as shown here.
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID
=104770
If you can find it in your heart to join "microsoft connect" and give them
your email, please add a comment to the above case asking them to fix it.

Signature
=======================================================================
Joseph "Beemer Biker" Stateson
http://TipsForTheComputingImpaired.com
http://ResearchRiders.org Ask about my 99'R1100RT
=======================================================================