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?


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

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.


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