Larry,
>sorry but another question for you...
>
>On a detail form in btnSave event at
>Me.Save(Me.oResource, dsResource, Me.oResource.TableName) I'm getting
>'SqlException was unhandled by user code': Invalid object name 'Message'.
>
>I've reduced the update procedure to no parameters and just a simple table insert, which runs okay directly. Inspecting oResource shows the data I'm trying to save. The form retrieves the data fine, I'm just updating the data (one record).
>
>I have no field or object named message.
>
>Any suggestions, do you recognize this error?
>
>...further to this I switched 'Use Dynamic SQL Statements' and regenerated dal, didn't help.
Can you post the full stack trace so I can better see what's going on?
Best 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