Correct DDR and SQL Schema Query output

Idea created by coherentkris on Aug 30, 2016
    Active
    Score6
    • Benjamin Fehr
    • arnoldkegebein
    • coherentkris
    • BeatriceBeaubien
    • Vincent_L
    • danshockley

    ExecuteSQL ( SELECT * FROM FileMaker_Tables" ; "" ; "" ) actually returns :

    1. TableOccurenceName
    2. TableOccurenceID
    3. BaseTableName
    4. BaseFileName
    5. ModCount

     

    ExecuteSQL ( SELECT * FROM FileMaker_Fields" ; "" ; "" ) actually returns :

    1. TableOccurenceName

    2. FieldName

    3. FieldType

    4. FieldID

    5. FieldClass

    6. FieldReps

    7. ModCount

     

    ExecuteSQL call to the FM table schema should return the TableID from the BaseTableCatalog AND the current output.

     

    The DDR outputs should also be changed to allow for the generally accepted descriptor of TableOccurence

    IE...

    <RelationshipGraph>

        <TableOccurenceList>

            <TableOccurence id="1065089" color="#787878" baseTableId="129" baseTable="table_test" name="table_test_to_1"/>

            <TableOccurence id="1065090" color="#777777" baseTableId="129" baseTable="table_test" name="table_test_to_2"/>

        </TableOccurenceList>

        <RelationshipList/>

    </RelationshipGraph>

     

     

    FM should also publish the results of the schema calls in the official documentation.