Contents x
    What tables should I use for ODBC queries?
    • 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    What tables should I use for ODBC queries?

    • Updated on 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The FIMS schema show tables that start with "SQL_" and others, with the same table name and no prefix. Which tables should link to using ODBC or JDBC? What is the difference between the two/how does FIMS use these tables?

    Display FIMS Tables and Fields

    Answer:

    SQL tables are views\virtual tables which were created to convert arrays, long character fields, field names to a format that does not cause SQL errors, so it is typically best to use SQL views with ODBC.
     

    For OBDC, you can use views or tables to query on data, but again best to use SQL.


    Was this article helpful?
    What's Next