I have created a table in Sql server 2014 with the columns: Id (int), Geom (geometry), RouteId (int), Desc (varchar(MAX)) I have succeeded in making the table mappable through MapInfo I have checked .TAB file for the table, that it has IsReadOnly = false
Stil when i try to execute an insert query on the table I get the error messsage that the table is read only. Anyone knows how to fix this?
Also I cannot figure out how to write a correct insert query I have tried doing that on a copied version of the table code is as follows
Dim rId As Integer
Dim oPline as Object
rId = 20
Dim t As String
t = "test"
Create pline into variable oPline 2 (1,2)(1,3)
Insert into TestGeom1 (Geom, RouteId, Desc) VALUES (oPline, rId, t)
Writing like above I get the error messsage field Geom does not exist in table TestGeom1 If i replace Geom with obj or just remove it completely i get the error Expression does not evaluate to a column or a table name. So please who can tell me what is the correct syntax for this?