Page 1 of 1

Spatial extensions and the StoredProc component?

Posted: Tue 24 Oct 2006 10:47
by upscene
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

Posted: Wed 25 Oct 2006 13:01
by Antaeus
Current MyDAC does not support spatial extensions but we are considering support of this feature in the next MyDAC version.

Posted: Wed 25 Oct 2006 13:04
by upscene
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