I have a local database(SQL CE) in my winforms application that I am trying to update with the following code. When the code runs it errors out.
Here is the Error - There was an error parsing the query. [ Token line number = 1,Token line offset = 109,Token in error = ) ]
Here is my code:
Dim myConn2 As SqlServerCe.SqlCeConnection = New SqlServerCe.SqlCeConnection("DataSource=|DataDirectory|\SSI.sdf")
Catch ex As Exception
Dim command2 As New SqlServerCe.SqlCeCommand("insert into insp_def_buildings(internalctl)select ctl_num from buildings_rooms where buildings_rooms.sel = 1)", myConn2)