Hi,

I do a search for a row:-

Code:
                sSQL = "SELECT * FROM DO_DEPARTMENT_ORDER WHERE DO_STORE_CODE='" & sqlDSXMLStoreDepts.Tables(0).Rows(iRows).Item("SD_ST_STORECODE") & "' AND "
                sSQL = sSQL & "DO_DEPT_CODE = '" & sqlDSXMLStoreDepts.Tables(0).Rows(iRows).Item("SD_DP_DEPT_CODE") & "'"
                sSQL += " AND DO_CY_CODE = '" & sOutputCompanyCode & "'"
                sqlDAStoreDepts = New SqlCeDataAdapter
                sqlDAStoreDepts.SelectCommand = New SqlCeCommand(sSQL, CeData)
                sqlDSStoreDepts = New DataSet
                sqlDAStoreDepts.Fill(sqlDSStoreDepts, "DO_DEPARTMENT_ORDER")
I amend some of the data (not the columns which make up the unique key):-

Code:
                        sqlDSStoreDepts.Tables(0).Rows(0).Item("DO_CY_CODE") = sqlDSXMLStoreDepts.Tables(0).Rows(iRows).Item("SD_CY_CODE")
                        sqlDSStoreDepts.Tables(0).Rows(0).Item("DO_DEPT_NAME") = sqlDSXMLStoreDepts.Tables(0).Rows(iRows).Item("SD_DEPT_NAME")
                        sqlDSStoreDepts.Tables(0).Rows(0).Item("DO_SORT_ORDER") = rppUtils.iNullTest(sqlDSXMLStoreDepts.Tables(0).Rows(iRows).Item("SD_SORT_ORDER"))
                        sqlDSStoreDepts.Tables(0).Rows(0).Item("DO_RECORD_STATUS") = "NO_CHANGE"
I then update the live database:-

Code:
                sqlCBStoreDepts = New SqlCeCommandBuilder(sqlDAStoreDepts)
                sqlDAStoreDepts.Update(sqlDSStoreDepts, "DO_DEPARTMENT_ORDER")
Its at this point I get the following error:-

Code:
Dynamic SQL generation for the update command is not supported against a select command that does not return any key column information
Does anyone know why I am getting this error. All I want to do is search for a row; if it exists update some columns and if not create a new row.

Thanks for any help,

Jiggy!