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