[fdo-users] Adding new featureclass from existing table

[bhogi]

Hi,

I'm adapting a few apps that export GIS data to SQL server 2008. The goal is
to make exported data also available to FDO.

In the beginning I solved the problem of making database tables available to
FDO by inserting class definitions etc. in f_ tables and adding classid and
revisionnumber fields to the tables. Althou working this "hack" is not
acceptable in the long run.

I want to do this the correct FDO way, but don't know how.

There are two approaches I was considering:

1) Create a table first and make it an FDO featureclass later
BUT If I create a new feature class intended for the already existing table,
the fdo will make a new differently named table.
I could change the values in f_ tables, but that's reverting to "hacking"
again.

2) Make an FDO featureclass and insert new features in corresponding table
via SQL as I did before
BUT classid and revisionnumber need to be set. If I set these values via SQL
I see this as reverting to "hacking" again.

Is there a way to acomplish this?
Have I overlooked something?
Is the 2) way considered as a valid way to insert features in featureclass.
What if the FDO internals will change regarding these fields...

Adding new features the FDO way is not an option, there's just too much code
to adapt.

Thanks.

-- 
View this message in context: http://n2.nabble.com/Adding-new-featureclass-from-existing-table-tp3828504p3828504.html
Sent from the FDO Users mailing list archive at Nabble.com.