[fdo-users] FDOPostGIS 3.4L AutoCAD Map 3d 2010 Data Connection to features with numberstring as a fieldname does not work

[Hermann Karl]

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