SQLDataAdapter problem framing dates

16 Mar 2006 8:45 PM

grondaia

I am using a SQLDataAdaper to update data into a database Im setting
the updatecommand to a stored procedure and creating all the
paramaters. All seems to create correctly, however the sql command
that is passed to the database is framing all the dates with double
single quotes....its executing with text like:

exec spUpdateMoveTransaction
@equipmentID=63,@originID=22,@destinationID=48,@moveStatusID=4,@lowBoyID=NULL,@moveDate=''2005-08-30

00:00:00:000'',@round=NULL,@startTime=NULL,@stopTime=NULL,@createdByID=88,@lastUpdatedByID=181,@lastUpdateDate=''2005-08-30
15:34:10:300''

i pasted that directly from a trace. Why is the sqldataadapter using
two single quotes insted of one single quote to wrap dates. Any ideas?

Thanks

16 Mar 2006 11:00 PM

William (Bill) Vaughn

Ah, this is by design (I expect). Since the dates are sent as quoted
literals they have to be framed in single quotes. However, so does the SQL
string itself. This doubling up of the quotes tells the SQL compiler to
leave these single quotes in place so it replaces '' with ' .

--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP
<grond***@gmail.com> wrote in message

Show quote

news:1142541918.887150.270940@v46g2000cwv.googlegroups.com...
>I am using a SQLDataAdaper to update data into a database Im setting
> the updatecommand to a stored procedure and creating all the
> paramaters. All seems to create correctly, however the sql command
> that is passed to the database is framing all the dates with double
> single quotes....its executing with text like:
>
> exec spUpdateMoveTransaction
> @equipmentID=63,@originID=22,@destinationID=48,@moveStatusID=4,@lowBoyID=NULL,@moveDate=''2005-08-30
>
> 00:00:00:000'',@round=NULL,@startTime=NULL,@stopTime=NULL,@createdByID=88,@lastUpdatedByID=181,@lastUpdateDate=''2005-08-30
> 15:34:10:300''
>
>
> i pasted that directly from a trace. Why is the sqldataadapter using
> two single quotes insted of one single quote to wrap dates. Any ideas?
>
>
> Thanks
>