OdbcDataAdapter Insert Command

[monteiro]

Hi,
I am using OdbcDataAdapter to insert data to postgreeSQL..
Everything’s seems to be fine, but nothing is inserting in the database. Andy Idea??
Thanks in advance

string selectCommand = "SELECT ROAD_ID, PONTOS  FROM geom";
OdbcDataAdapter adapter = new OdbcDataAdapter(selectCommand, connection);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
try
   {
      adapter.InsertCommand = new OdbcCommand("INSERT INTO geom (ROAD_ID,PONTOS) " + "VALUES (4,GeomFromText('POINT(2000 243118 191108)',-1));");
}

......

[debasisdas]

Are you getting any error from the code ?

What is GeomFromText('P OINT in your code ?

[monteiro]

Are you getting any error from the code ?
What is GeomFromText('P OINT in your code ?

No i don´t receive any error.
GeomFromText is used to convert a Spatial reference system, version of a geometry into a PostGIS geometry.