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.Transf erQueue
(Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
Story', 'Mtns, Utah', ', ;',
'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 Nameaily Experience
Page Name:Back
Department Name:News
Event Name:Inauguration Day
Run Date:01/20/2009
ABCSTORYEND
********************
ABCMEDIA
Media Type:Photo
Number of Photos:12
Budget Run Date:03/01/2009
Event:s
Edition:s
Contact Name:gg
Contact Phone:555-4444
Address:123 Street
City:Provo
State:Utah
Directions:There and back again.
Notes:Some notes
Story Name:Some story name.
ABCMEDIAEND
',
'040000008200E00074C5B7101A82E00800000000D0F6740E6 822CA01000000000000000010000000B2D52BAB53A87544B55 53FD249066739')

SQL Example END

Outlook related how?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"pkelley" wrote in message
...
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.Transf erQueue
(Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
Story', 'Mtns, Utah', ', ;',
'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 Nameaily Experience
Page Name:Back
Department Name:News
Event Name:Inauguration Day
Run Date:01/20/2009
ABCSTORYEND
********************
ABCMEDIA
Media Type:Photo
Number of Photos:12
Budget Run Date:03/01/2009
Event:s
Edition:s
Contact Name:gg
Contact Phone:555-4444
Address:123 Street
City:Provo
State:Utah
Directions:There and back again.
Notes:Some notes
Story Name:Some story name.
ABCMEDIAEND
',
'040000008200E00074C5B7101A82E00800000000D0F6740E6 822CA01000000000000000010000000B2D52BAB53A87544B55 53FD249066739')

SQL Example END