Spatial extensions and the StoredProc component?

upscene · Post by **upscene** » Tue 24 Oct 2006 10:47

Hi,

Are the spatial extensions supported by the StoredProc component?

I'm getting this error when trying it in my own application, but want to make sure whose fault it is

Code: Select all

Unknown column type "POINT" in "point"

Any idea?

The full function is:

Code: Select all

CREATE FUNCTION new_point()
  RETURNS point
begin
  return PointFromText('Point(10 10)');
end

--
Martijn Tonies
Upscene Productions

Antaeus · Post by **Antaeus** » Wed 25 Oct 2006 13:01

Current MyDAC does not support spatial extensions but we are considering support of this feature in the next MyDAC version.

upscene · Post by **upscene** » Wed 25 Oct 2006 13:04

Please do so. Retrieving the data with a SELECT shows "(BLOB)", which is a start

Anyway, I would be needing this, since I'm creating Spatial Extensions support in Database Workbench, which uses your componentset.

--
Martijn Tonies
Upscene Productions