"Invalid input parameter values." Master/Child

[Bill Gage]

I am trying to edit the master dataset of a master/child relationship. Either by appending or inserting a new record. However whenever I try I get the error "Invalid input parameter values. Check the status values for details." How do I resolve this error? Or prevent it from occuring?

Bill

[tinof]

Hi,

look at details - query (table) properties. After setting up a master/detail relationsship you will see one ore more parameters (your linking fields). Set the datatype - properties for these automatically generated parameters.

Tino

[Ikar]

Please see MasterDetail demo from Demos folder.

[Bill Gage]

The Master/Detail parameters have been set up and it seems to be functioning fine when I am navigating the datasets. The only time I get the aforementioned error is when I try to append or insert a record into the master dataset. However, I will follow the advice of Ikar and tinof and check both of their suggestions and post my results here.

[Bill Gage]

Here is what resolved the above issue.

Apparantly whenever a new record was insterted into the Master dataset, whatever the initial value the Master Field was being set to would cause the error.

So using the fields editor on the Master Dataset I retrieved the fields and set the default value of the master field. This corrected the issue.

As an opinion I have not noticed other dataset components that connect to the BDE or Interbase to cause this same issue. So it would seem to me the methods that enable the master/detail functionality should be disabled when the Master dataset enters the edit mode, or at least the methods should make an exception to the master/detail param rules when the master dataset is being edited.

Bill