P
pkelley
Below is an example of a VERY long SQL command generated by an Add-In.
My question is does anyone know if there is a maximum size imposed by either
the Microsoft.Data.Odbc.OdbcCommand field or the
Microsoft.Data.Odbc.ExecuteNonQuery() command?
I'm afraid if the query gets too big, an OdbcExcpetion will be thrown. Not
sure what the limit is?
<<<< SQL Example SNIP >>>
INSERT INTO dtens_lqm_fw_queues_budgetstoryqueue_v1_cls.TransferQueue
(Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
Story', 'Mtns, Utah', '(e-mail address removed)', '(e-mail address removed);',
'8/21/2009 2:00:00 PM', '8/21/2009 2:30:00 PM', '<<ABCSTORY>>
Min Story Depth:5
Max Story Depth:12
Budget Summary:Here’s a budget summary
Edition Name
aily Experience
Page Name:Back
Department Name:News
Event Name:Inauguration Day
Run Date:01/20/2009
<<ABCSTORYEND>>
********************
<<ABCMEDIA>>
Media Type
hoto
Number of Photos:12
Budget Run Date:03/01/2009
Event:s
Edition:s
Contact Name:gg
Contact Phone:555-4444
Address:123 Street
Cityrovo
State:Utah
Directions:There and back again.
Notes:Some notes
Story Name:Some story name.
<<ABCMEDIAEND>>
',
'040000008200E00074C5B7101A82E00800000000D0F6740E6822CA01000000000000000010000000B2D52BAB53A87544B5553FD249066739')
<<<< SQL Example END >>>>
My question is does anyone know if there is a maximum size imposed by either
the Microsoft.Data.Odbc.OdbcCommand field or the
Microsoft.Data.Odbc.ExecuteNonQuery() command?
I'm afraid if the query gets too big, an OdbcExcpetion will be thrown. Not
sure what the limit is?
<<<< SQL Example SNIP >>>
INSERT INTO dtens_lqm_fw_queues_budgetstoryqueue_v1_cls.TransferQueue
(Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
Story', 'Mtns, Utah', '(e-mail address removed)', '(e-mail address removed);',
'8/21/2009 2:00:00 PM', '8/21/2009 2:30:00 PM', '<<ABCSTORY>>
Min Story Depth:5
Max Story Depth:12
Budget Summary:Here’s a budget summary
Edition Name
aily ExperiencePage Name:Back
Department Name:News
Event Name:Inauguration Day
Run Date:01/20/2009
<<ABCSTORYEND>>
********************
<<ABCMEDIA>>
Media Type
hotoNumber of Photos:12
Budget Run Date:03/01/2009
Event:s
Edition:s
Contact Name:gg
Contact Phone:555-4444
Address:123 Street
City
rovoState:Utah
Directions:There and back again.
Notes:Some notes
Story Name:Some story name.
<<ABCMEDIAEND>>
',
'040000008200E00074C5B7101A82E00800000000D0F6740E6822CA01000000000000000010000000B2D52BAB53A87544B5553FD249066739')
<<<< SQL Example END >>>>