Hrm.  What is the exception that it throws?

Thanks Ben,

That did it.

So, now I have another problem. The business object throws an error when I save to another table that does not have a primary key when I attempt to create a record.

Thanks

Michael 

On the business object itself, is the PrimaryKeyIsAutoIncremented property set to True?  It should be in the CRUD category in the designer. It doesn't matter how the data source's table is actually configured.  If that property on the business object it True, it's going to cause that error.

I am getting an error adding a record to a table that does not have a primary key. The message states that I cannot insert a command because PrimaryKeyisAutoincremented = true and the PrimaryKeyField is not a valid auro-increment data type.

The table does not have a Primary Key or autoincrementing primary key set to Auto increment.

Any Ideas?

Sample code below.

                                '-- Create a new record
                                .NewRow()
                                'Save Log Record
                                LocHL7Data.MessageID = System.Guid.NewGuid.ToString() 'Loc_PID_SEG_BO.MessageID
                                'LocHL7Data.MessageSize = oMsg.
                                LocHL7Data.VendorVersion = oMsg.VendorVersion
                                LocHL7Data.VendorName = oMsg.VendorName
                                LocHL7Data.MsgControl = sCrlID
                                LocHL7Data.PartnerAPP = ""
                                LocHL7Data.DateLoaded = System.DateTime.Now.ToString
                                LocHL7Data.HL7Message = oMsg.HL7
                                LocHL7Data.SegmentCount = oMsg.SegmentCount
                                LocHL7Data.MsgType = sMsgType1

                                '-- Save the record
                                If .Save() <> MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
                                    MsgBox("Save Failed...")
                                End If
                            End With