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 inserting or updating the spatial geometry datafield:
INSERT INTO SpatialTable (Geometry, name) VALUES (
geometry::GeomFromText(
'LINESTRING (100 100,20 180,180 180)','first');
Update
When running INSERT command directly inside spatialite GUI :
INSERT INTO newtbl (Geometry) VALUES (GeomFromText('LINESTRING (111 111,20 180,180 180)' ))
the geometry field looks like this: BLOB sz=96 GEOMETRY
But when I run the same command with powerbuilder script:
INSERT INTO newtbl (Geometry) VALUES (GeomFromText('LINESTRING (100 100,20 180,180 180)');
the geometry field data looks like this: LINESTRING (100 100,20 180,180 180)
I do not know how to fire SpatiaLite's function "GeomFromText" from PowerBuilder. Please for help
