Wow, thanks for quick answer ... and special for attached document ...
<br />
<br />
This document is very helpful and explain a lot.
<br />
I can't still figure out meaning of columns <b>attributetype</b> and <b>geometrytype</b> in table <b>f_attributedefinition</b>
<br />
<br />
<b>Are they populated from some ENUMs, CONSTANTs or are they calculated somehow? </b><br />
<br />
>From your document:
<br />
<b>attributetype</b> = FDO property type.
<br />
<b>geometrytype</b> = Detailed geometry types allowed for this column.
<br />
<br />
Here are some of the values from table <b>f_atributedefinition</b> from different databases
<br />
<br />
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse:
collapse;width:283pt" width="376">
<colgroup>
<col style="mso-width-source:userset;mso-width-alt:3986;width:82pt"
width="109" />
<col style="mso-width-source:userset;mso-width-alt:2962;width:61pt"
width="81" />
<col style="mso-width-source:userset;mso-width-alt:3291;width:68pt"
width="90" />
<col style="mso-width-source:userset;mso-width-alt:3510;width:72pt"
width="96" />
</colgroup>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt;width:82pt" width="109">
Works with</td>
<td class="style1" width="81">
<b>columntype</b></td>
<td class="style2" width="90">
<b>attributetype</b></td>
<td class="style3" width="96">
<b>geometrytype</b></td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Point</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
1</td>
<td align="right" class="style5">
576</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Point</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
1</td>
<td align="right" class="style5">
64</td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Line or..</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
2</td>
<td align="right" class="style5">
42112</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Line or..</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
7</td>
<td align="right" class="style5">
126912</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Line or..</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
2</td>
<td align="right" class="style5">
1152</td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Polygon or..</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
4</td>
<td align="right" class="style5">
256</td>
</tr>
<tr height="20" style="height:15.0pt">
<td class="style4" height="20">
Polygon or..</td>
<td class="style5">
geometry</td>
<td align="right" class="style5">
4</td>
<td align="right" class="style5">
84224</td>
</tr>
</table>
<br /><div class="signature"><hr>
Srecko Lipovsek<br />
Kaliopa d.o.o., Ljubljana, Slovenija
</div>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Tool-for-editing-f-tables-in-SQL-2008-tp5673979p5676696.html">Re: Tool for editing f_ tables in SQL 2008?</a><br>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html">FDO Users mailing list archive</a> at Nabble.com.<br>