<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18854">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Verdana>good questions, </FONT></DIV>
<DIV><FONT size=2 face=Verdana>the documentation is very poor, is need to
digging in this tables</FONT></DIV>
<DIV><FONT size=2 face=Verdana>we start to make a procedure to create from sql
to f_tables all tables and populate them but we thinking is not be useful and we
give up ...</FONT></DIV>
<DIV><FONT size=2 face=Verdana>The most lack using FDO schema in Map, is not
possible to manage views, and non spatial data (there is no options to add data)
, modifying the data structure or adding/modifying views is difficult
.</FONT></DIV>
<DIV><FONT size=2 face=Verdana>We choose to create datastore directly in
sqlserver without any FDO schema, It's fast but has a problem for user because
the feature type can be mixt (point, line, polygon) and not always want this,
but with triggers can be easily controlled.</FONT></DIV>
<DIV><FONT size=2 face=Verdana>But the most unlike is that in map display style
is show all tree type of feature class.</FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT> </DIV>
<DIV><FONT size=2 face=Verdana></FONT> </DIV>
<DIV><FONT size=2 face=Verdana>kalmy</FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=srecko.lipovsek@kaliopa.si
href="mailto:srecko.lipovsek@kaliopa.si">Srecko Lipovsek</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=fdo-users@lists.osgeo.org
href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 26, 2010 12:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [fdo-users] Tool for editing f_
tables in SQL 2008?</DIV>
<DIV><BR></DIV>Hi <BR>We store all spatial data in SQL 2008. All DB-s also
includes f_ tables for describing Schemas and Clases. <BR><BR>We realize that
<B>f_</B> tables are now optional in SQL 2008, but they are great because they
provide clean and organized data. <BR><BR>The only problem when using f_
tables is how to add new feature class from new table or some view.
<BR><BR>When we import data to SQL with non FDO provider, only table is
created and f_ tables are not populated. Also when some new view is created,
we have manualy populate f_ tables if we want to view data. When one new
column on existing class is created also something with f_ tables, ... there
is many cases when manualy editing of f_ tables should be done to corectly
view data ... <BR><BR>We know, that with some tricks (copy data from one to
another DB with no f_ tables and back) should work, but I think that TOOL or
PROCEDURE should be the best way for reading psyihical SQL objects maping and
writing it to f_ tables (and also checker if something is deleted) ...
<BR><BR>Editing f_ tables by hand is very tricky, so: <BR><BR><B>1.)</B> I'am
wondering if there is some <B>TOOL</B> or <B>SQL PROCEDURE</B> for editing
(check, read, write) f_ tables in SQL 2008 (SQL objects phyisical mapping to
f_ tables and vice versa)? <BR><BR><B>2.)</B> Whether this can be done via the
FDO API? <BR><BR><B>3.)</B> Is there any <B>DOCUMENTATION</B> for f_ tables?
<BR><BR>
<DIV class=signature>
<HR>
Srecko Lipovsek, BSc Civil Engineer <BR>Kaliopa d.o.o., Ljubljana, Slovenija
<BR>WWW: <A href="http://www.Kaliopa.si?by-user=t" rel=nofollow target=_top
link="external">www.Kaliopa.si</A> | <A href="http://www.iObcina.si?by-user=t"
rel=nofollow target=_top link="external">www.iObcina.si</A> | <A
href="http://gis.iObcina.si?by-user=t" rel=nofollow target=_top
link="external">gis.iObcina.si</A> | <A
href="http://www.iSlovenija.si?by-user=t" rel=nofollow target=_top
link="external">www.iSlovenija.si</A> | <A
href="http://www.iKomunala.si?by-user=t" rel=nofollow target=_top
link="external">www.iKomunala.si</A></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-tp5673979p5673979.html">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>
<P>
<HR>
<P></P>_______________________________________________<BR>fdo-users mailing
list<BR>fdo-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/fdo-users<BR><BR><BR><BR>__________
Information from ESET Smart Security, version of virus signature database 5554
(20101022) __________<BR><BR>The message was checked by ESET Smart
Security.<BR><BR>http://www.eset.com<BR><BR></BLOCKQUOTE><BR><BR>__________
Information from ESET Smart Security, version of virus signature database 5554
(20101022) __________<BR><BR>The message was checked by ESET Smart
Security.<BR><BR><A
href="http://www.eset.com">http://www.eset.com</A><BR><BR>
<BR>
__________ Information from ESET Smart Security, version of virus signature database 5554 (20101022) __________<BR>
<BR>
The message was checked by ESET Smart Security.<BR>
<BR>
<A HREF="http://www.eset.com">http://www.eset.com</A><BR>
</BODY></HTML>