How do I stop VS2005 from backward-quoting identifiers on update statements?
- From: Heinz Kiosk <sales@xxxxxxxxxxx>
- Date: Thu, 31 Jan 2008 04:16:47 -0800 (PST)
I'm using the VS2005 wizard/design tool for generating typed
datatables and adapters for a desktop application. At design-time I
point the development environment at an MSJet database, but I've been
careful to make all of the queries that I add to the adapters generic
SQL which should work against most environments (or at least MS SQL
Server, which I also want to target)
BUT, the update/insert/delete statements that are being handily
generated by the wizard are cloaking all of the identifiers with
backward quotes which work OK with MSJet but not when I shift the
connection to MS SQL Server at run time. Is there any way of stopping
that backward-quoting behaviour at design time? I cannot see it...
.
- Prev by Date: Oracle connection Fails
- Next by Date: Re: Inserting records from one database into identical table in anothe
- Previous by thread: Oracle connection Fails
- Next by thread: Data table export to CSV?
- Index(es):