SpatiaLite with PowerBuilder

May 24, 2012 at 10:18 AM

I want to send data for points and lines from Sybase to DotSpatial project using SpatiaLite.

ODBC connection between PowerBulder 11.5 Sybase SQL and SpatiaLite SQL works OK except for the inserting or updating spatial geometry datafield:

INSERT INTO SpatialTable (Geometry, name) VALUES (

  geometry::GeomFromText(

   'LINESTRING (100 100,20 180,180 180)','first');

Please I need help on this.
Thanks, Vojko

Jun 11, 2012 at 6:45 AM

 

Now I find with Sandro's help the correct syntax which works OK: 

string wkt, name 

wkt = 'LINESTRING(521510 125444, 521749 125370, 521894 125218)'; 
INSERT INTO pipes (pipe_name, Geometry) VALUES ( :name, GeomFromText(:wkt, 
2170)) USING SQLCA_SP; 

bye Vojko