Database & SQL

Moderators: None (Apply to moderate this forum)
Number of threads: 1186
Number of posts: 2239

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
PowerBuilder to SpatiaLite Posted by vzavec on 24 May 2012 at 3:34 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 inserting/updating the spatial geometry datafield.

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 the geometry field data looks like this: LINESTRING (100 100,20 180,180 180)

How to fire SpatiaLites function "GeomFromText" from PowerBuilder script.

Please I need help on this.
Thanks, Vojko



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.