<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>FDOPostGIS 3.4L AutoCAD Map 3d 2010 Data Connection to features with numberstring as a fieldname does not work</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Dear List,</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">BEGIN;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE TABLE "blocktest2" (gid serial PRIMARY KEY,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"blockname" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"layer" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"rotation" numeric,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"3" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"u" varchar(255));</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">SELECT AddGeometryColumn('','blocktest2','the_geom','-1','POINT',2);</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">INSERT INTO "blocktest2" ("blockname","layer","rotation","3","u",the_geom) VALUES ('GN1','GN','0.000000000000000','789',NULL,'0101000000FDA08A2C9FB3E3C0B9770762A8FA0E41');</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">INSERT INTO "blocktest2" ("blockname","layer","rotation","3","u",the_geom) VALUES ('GN2','GN','0.000000000000000','2345','6','0101000000E54B15C275B3E3C053379F6D81F90E41');</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">END;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">trying to add this postgis featureset to the map causes</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">the error messages below</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Storage of the objects in the Cache failed</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">The execution of the select command failed</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">the fdo driver tries do select with following syntax</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">select "public"."blocktest2".3 from "public"."blocktest2";</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">the error message from postgres is</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">ERROR: syntax error at or near ".3"</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">SQL state: 42601</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Character: 29</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">select "public"."blocktest2"."3" from "public"."blocktest2";</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">would work in postgres</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Karl</FONT></SPAN>
</P>
<BR>
<BR>
</BODY>
</HTML>