I want to export all point fields?

[sbeadle]

Someone asked me recently whether they can export all point configuration to a file so that they can compare and report on it. They asked if SELECT * FROM CDBPOINT will do that.

My answer was no, many configuration fields are in child tables descended from CDBPoint because the database is object-oriented.

Anyway, I suggested first to use the query SELECT DISTINCT TYPENAME FROM CDBPOINT to get a list of the tables in which point data is stored for the application, then use SELECT * <table> for each one.

Of course, there will be many irrelevant fields to ignore depending on what the comparison is for.

The Bulk Edit tool could be used to do this too.