Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
You might want to put in any errors you are getting in order for someone to help diagnose the problem. – Chad Cooper May 25 '12 at 15:46

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.