Recent

Author Topic: how to read and write sql spacial data with pascal  (Read 2510 times)

bernhard

  • Newbie
  • Posts: 1
how to read and write sql spacial data with pascal
« on: August 12, 2017, 01:06:18 pm »
I could not find information on using   sql spacial data with PASCAL ( https://docs.microsoft.com/de-de/sql/relational-databases/spatial/spatial-data-sql-server )
guess the data access will be stored procedures on the server, but how to get these data (data types)  into my own code on the client side?


Any code examples will be fine 
« Last Edit: August 12, 2017, 01:08:52 pm by bernhard »

Thaddy

  • Hero Member
  • *****
  • Posts: 14214
  • Probably until I exterminate Putin.
Re: how to read and write sql spacial data with pascal
« Reply #1 on: August 12, 2017, 02:57:13 pm »
This link is a little more appropiate. Not everyone here understands German:
https://docs.microsoft.com/en-us/sql/relational-databases/spatial/spatial-data-sql-server

Note that spatial data is not in any way part of any SQL specification. It is a .net based extension to SQL server only. i:e: it has not much to do with SQL. It is a language extension. Basically user-defined procedures. On the client side it simply looks like any other result set.
« Last Edit: August 12, 2017, 03:04:59 pm by Thaddy »
Specialize a type, not a var.

avra

  • Hero Member
  • *****
  • Posts: 2514
    • Additional info
ct2laz - Conversion between Lazarus and CodeTyphon
bithelpers - Bit manipulation for standard types
pasettimino - Siemens S7 PLC lib

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11383
  • FPC developer.
Re: how to read and write sql spacial data with pascal
« Reply #3 on: August 13, 2017, 12:58:18 pm »
afaik OSM primarily uses Postgresql?  The data side of postgres' spatial extensions are afaik layered over structure support, which afaik the FPC driver supports.

 

TinyPortal © 2005-2018