SQL Server and Access
I get very confused about what in a access sql command required brackets/quotes.
Where can I go in the forums to get questions addressed regarding access?
Dim
UpdateCommand = "UPDATE " & AdditionStructure.DatabaseTable & " SET ChildIndexList = @ChildIndexList FROM " & AdditionStructure.DatabaseTable & " WHERE (ID = @ID)"
Dim MyUpdateCommandAsNew OleDbCommand(UpdateCommand, Con)MyUpdateCommand.Parameters.Add("@ID", AdditionStructure.ParentId)
MyUpdateCommand.Parameters.Add("@ChildIndexList", AdditionStructure.ParentChildIndexList)
MyUpdateCommand.ExecuteNonQuery()

