>I am trying to insert into from memvar into a table that has default values set by stored procedure. Insert into from memvar does an annoying thing which is write nothing to any unspecified field. This is a violation of a unique index and I get of all things, a data type mismatch. Then you say OK to the error it processes the stored procedure anyway and everything is hunky dorey again. Fine for me but my client doesn't like annoying error messages. Is there a fast way to get rid of this message without jumping through too many hoops?
>
>Eric K.
Eric,

Use the defaultValue setting in the dbc to give your new record a unique ID. Waiting for the Rules or triggers is too late as you can see the index is checked before those events fire.