When trying to specify any additional information with an updating an appointment I am getting a "Error Updating Appointments table". Incorrect Syntax near 'Nothing'.
What could be wrong with the update statement. I am using SQL Server 2008. When tracing the insert through SQL Server Profiler the following statement is used to attempt an update.
exec sp_executesql N'UPDATE Appointments SET AllProperties = @P1, StartDateTime = @P2, EndDateTime = @P3, Subject = @P4, AllDayEvent = @P5, OwnerKey = @P6 WHERE (AppointmentID = @P7) AND (AllDayEvent = @P8) AND (AllProperties = @P9 OR @P10 IS Nothing AND AllProperties IS Nothing) AND (EndDateTime = @P11) AND (OwnerKey = @P12 OR @P13 IS Nothing AND OwnerKey IS Nothing) AND (StartDateTime = @P14) AND (Subject = @P15) SELECT AppointmentID, AllProperties, StartDateTime, EndDateTime, Subject, AllDayEvent, OwnerKey FROM Appointments WHERE (AppointmentID = @P16)',N'@P1 varbinary(1024),@P2 datetime,@P3 datetime,@P4 varchar(50),@P5 bit,@P6 varchar(50),@P7 int,@P8 bit,@P9 varbinary(1024),@P10 varbinary(1024),@P11 datetime,@P12 varchar(50),@P13 varchar(50),@P14 datetime,@P15 varchar(50),@P16 int',0x0001000000FFFFFFFF01000000000000000C0200000071496E66726167697374696373322E57696E2E556C74726157696E5363686564756C652E76392E312C2056657273696F6E3D392E312E32303039312E313030302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D376464356333313633663263643063620C030000005153797374656D2E44726177696E672C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D6230336635663766313164353061336105010000002D496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E740C00000006416374696F6E08426172436F6C6F72075375626A656374084C6F636174696F6E0B4465736372697074696F6E0D53746172744461746554696D650B456E644461746554696D65084F776E65724B65790852656D696E646572154F726967696E616C53746172744461746554696D650A446972747950726F70730D4F726967696E616C496E64657804040101010000010400000033496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E020000001453797374656D2E44726177696E672E436F6C6F72030000000D0D2A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E646572020000000D0F0802000000090400000005FBFFFFFF1453797374656D2E44726177696E672E436F6C6F7204000000046E616D650576616C75650A6B6E6F776E436F6C6F7205737461746501000000090707030000000A0080FFFF000000000000020006060000002153535353535353535353535353535353535353535353535353535353535353535306070000002376767676767676767676767676767676767676767676767676767676767676767676760608000000276E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E2D414141414141414100F81B8852D3CB0800128DA054D3CB0806090000000138090A00000000F81B8852D3CB880000000000000080050400000033496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E0100000007456E61626C656400010200000000050A0000002A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E6465720200000007456E61626C65640E536E6F6F7A65496E74657276616C000001080200000001000000000B,'2009-07-15 11:00:00','2009-07-15 11:15:00','SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS',0,'8',13,0,0x0001000000FFFFFFFF01000000000000000C0200000071496E66726167697374696373322E57696E2E556C74726157696E5363686564756C652E76392E312C2056657273696F6E3D392E312E32303039312E313030302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D376464356333313633663263643063620C030000005153797374656D2E44726177696E672C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D6230336635663766313164353061336105010000002D496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E740C0000001444617465734173556E6976657273616C54696D6506416374696F6E08426172436F6C6F72075375626A656374084C6F636174696F6E0B4465736372697074696F6E0D53746172744461746554696D650B456E644461746554696D65084F776E65724B65790852656D696E6465720A446972747950726F70730D4F726967696E616C496E6465780004040101010000010400000133496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E020000001453797374656D2E44726177696E672E436F6C6F72030000000D0D2A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E646572020000000F080200000001090400000005FBFFFFFF1453797374656D2E44726177696E672E436F6C6F7204000000046E616D650576616C75650A6B6E6F776E436F6C6F7205737461746501000000090707030000000A0080FFFF0000000000000200060600000021535353535353535353535353535353535353535353535353535353535353535353060700000023767676767676767676767676767676767676767676767676767676767676767676767606080000001E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E009057264AD3CB4800AAC83E4CD3CB4806090000000138090A0000000000000000000080050400000033496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E0100000007456E61626C656400010200000000050A0000002A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E6465720100000007456E61626C6564000102000000010B,0x0001000000FFFFFFFF01000000000000000C0200000071496E66726167697374696373322E57696E2E556C74726157696E5363686564756C652E76392E312C2056657273696F6E3D392E312E32303039312E313030302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D376464356333313633663263643063620C030000005153797374656D2E44726177696E672C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D6230336635663766313164353061336105010000002D496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E740C0000001444617465734173556E6976657273616C54696D6506416374696F6E08426172436F6C6F72075375626A656374084C6F636174696F6E0B4465736372697074696F6E0D53746172744461746554696D650B456E644461746554696D65084F776E65724B65790852656D696E6465720A446972747950726F70730D4F726967696E616C496E6465780004040101010000010400000133496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E020000001453797374656D2E44726177696E672E436F6C6F72030000000D0D2A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E646572020000000F080200000001090400000005FBFFFFFF1453797374656D2E44726177696E672E436F6C6F7204000000046E616D650576616C75650A6B6E6F776E436F6C6F7205737461746501000000090707030000000A0080FFFF0000000000000200060600000021535353535353535353535353535353535353535353535353535353535353535353060700000023767676767676767676767676767676767676767676767676767676767676767676767606080000001E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E6E009057264AD3CB4800AAC83E4CD3CB4806090000000138090A0000000000000000000080050400000033496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E4170706F696E746D656E74416374696F6E0100000007456E61626C656400010200000000050A0000002A496E667261676973746963732E57696E2E556C74726157696E5363686564756C652E52656D696E6465720100000007456E61626C6564000102000000010B,'2009-07-15 11:15:00','8','8','2009-07-15 11:00:00','SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS',13
I haven't messed around much with SQLServer2008 yet, but one thing that comes to mind with any SQL generated error is that the table has some additional fields that aren't being written to, and those fields are configured to require a value. The error message indicates badly formed SQL, so that is another possibility, although I can't tell what that might be from what you posted here.
Also note that if you are working with a modified version of the 'WinSchedule Database Demo' sample, there is code in the data adapter classes that makes assumptions about the structure of the table, so you might need to modify the adapter code if you port this to SQLServer2008.
There is an error on the example.