[fdo-users] King MS SQL Spatial performance problem
haris at sl-king.com
Fri Jun 29 05:54:14 EDT 2007
I am not sure if I am interpreting emails correctly, anyhow:
FDO provider is using identity column to create a JOIN.
Column name can be any name not just ID or OID it is important that
column is set as IDENTITY column in SQL Server.
Have you created 'dbo.pokus' table with Fdo2Fdo ( It will set identity
column when copying data ) or some other way ?
From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Binter Jan
Sent: Friday, June 29, 2007 9:54 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] King MS SQL Spatial performance problem
The problem is that FDO provider expect different value name in
ST.FilterQuery function than it is in the function. FDO expect "ID" but
in function is "OID".
To be sure the problem is really in the name we tried to change
ST.FilterQuery function which is part of MS SQL Spatial. We changed only
the name from "OID" to "ID" and then it works.
Same problem is also in ST.RelateQuery function.
fdo-users mailing list
fdo-users at lists.osgeo.org
More information about the fdo-users