[fdo-users] FDOPostGIS 3.4L AutoCAD Map 3d 2010 Data Connection to
features with numberstring as a fieldname does not work
Hermann Karl
Karl.Hermann at dornbirn.at
Tue Aug 4 11:53:54 EDT 2009
Dear List,
BEGIN;
CREATE TABLE "blocktest2" (gid serial PRIMARY KEY,
"blockname" varchar(255),
"layer" varchar(255),
"rotation" numeric,
"3" varchar(255),
"u" varchar(255));
SELECT AddGeometryColumn('','blocktest2','the_geom','-1','POINT',2);
INSERT INTO "blocktest2"
("blockname","layer","rotation","3","u",the_geom) VALUES
('GN1','GN','0.000000000000000','789',NULL,'0101000000FDA08A2C9FB3E3C0B9
770762A8FA0E41');
INSERT INTO "blocktest2"
("blockname","layer","rotation","3","u",the_geom) VALUES
('GN2','GN','0.000000000000000','2345','6','0101000000E54B15C275B3E3C053
379F6D81F90E41');
END;
trying to add this postgis featureset to the map causes
the error messages below
Storage of the objects in the Cache failed
The execution of the select command failed
the fdo driver tries do select with following syntax
select "public"."blocktest2".3 from "public"."blocktest2";
the error message from postgres is
ERROR: syntax error at or near ".3"
SQL state: 42601
Character: 29
select "public"."blocktest2"."3" from "public"."blocktest2";
would work in postgres
Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20090804/6e90fff4/attachment-0001.html
More information about the fdo-users
mailing list