dbTalk Databases Forums  

customize: sql delimeter from [ and ] to " possible?

comp.databases.postgresql comp.databases.postgresql


Discuss customize: sql delimeter from [ and ] to " possible? in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Beemer Biker
 
Posts: n/a

Default customize: sql delimeter from [ and ] to " possible? - 04-26-2007 , 05:50 PM






Configured a SqlDataSource using this example:
http://www.123aspx.com/redir.aspx?res=35840

Running that "Generate INSERT, UPDATE dn DELETE statements" in Visual
Studio 2005 generates code for MS SQL. but uses [ and ]. instead of " which
is used by postgreseql

I need " and was wondering if there was a custom setting or project property
in VS2005 to change the sql delimeters?

The following would work if I changed all the [ and ] to "

====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====


...thanks in advance..


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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.