>Kevin,
>
>#1 The error in saving data is not related to VFP, the same happens if I make my table a SQL Server table. The error occurs in the line:
> this.SesBizObj.SaveDataSet(dsSessions);
Gotcha...this is due to the way that character fields are handled in .NET. If you use varchar fields instead, this works like a charm. We're adding a new Trim property to Windows and Web Forms controls in the next release that will handle trimming the extra spaces automatically.
>#2 Concerning the failed trigger error, I am not sure I understand what you mean. The failed trigger is a relational integrity trigger.
I was simply stating that a business rule object can be set up to determine whether the data is of the proper range before it ever gets saved.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com