http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 07:08:23 +0000 Fri, 25 May 2007 12:55:44 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=7218 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23251&title=save-method-not-saving#23251 Author: hildegoat
Subject: 7218
Posted: 25 May 2007 at 12:55pm

Okay, I was somewhat wrong with my diagnosis. It turns out that the AllowZeroLength property of the text fields in the Event table were set to No and I my code to build the event puts empty strings in a few fields. If I set the AllowZeroLength to Yes, my saving works. I added my custom fields back in, and the table still works, so it wasn't my custom fields that were causing the problem.

So I should still be able to add my own fields to the tables, which keeps my database (relatively) simple.
]]> Fri, 25 May 2007 12:55:44 +0000 http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23251&title=save-method-not-saving#23251 http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23249&title=save-method-not-saving#23249 Author: hildegoat
Subject: 7218
Posted: 25 May 2007 at 11:49am

I think I've figured it out. I removed my added fields from the Event table and it seems to work. It seems like the built-in data provider code doesn't like a modified table and just refuses to commit data without an error.]]> Fri, 25 May 2007 11:49:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23249&title=save-method-not-saving#23249 http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23183&title=save-method-not-saving#23183 Author: hildegoat
Subject: 7218
Posted: 23 May 2007 at 5:09pm

I currently have the calendar control working on a VB.NET front-end with a SQL Server 2000 back end (custom data provider). Since I'm still having speed issues with it, I thought I'd try it with an Access back-end instead and use built-in data provider code.

It looks like it works properly (i.e. the events in my .mdb populate into the calendar), but when I call CalendarControl.DataProvider.Save() the data doesn't save back to the source database.

I've modified an event and stepped through the code.  The EventChanged event fires, but I then do the Save call and nothing happens, not even an error.

I'm able to write to the mdb because I run an OLEDBCommand to update the ModifiedDate in the Event table (a field I added) during the EventChanged event, so it doesn't seem to be a permissions issue. Do you have any ideas of what could be going on?
]]> Wed, 23 May 2007 17:09:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=7218&PID=23183&title=save-method-not-saving#23183