To anyone with some SQL experience in filemaker:
Is there a simple method to obtain the column names returned by an SQL select?
fm_sql_select() only returns data - does Filemaker have a similar query to MySQL's SHOW COLUMNS FROM ?
Thanks for any insights...
Hi, sqlcolumns is supposed
Hi,
sqlcolumns is supposed to work according to the ODBC/JDBC documentation, but how do i use it with SmartPill?
System Tables
Hello Tomas,
FileMaker has 2 system tables that you can select from in any file. You should be able to get the table and field metadata you need here. Here's what the tables look like so you know what to select:
Filemaker_Tables
TableName -- varchar The name of the table
TableId -- int The table's unique id
BaseTableName -- varchar The name of the base table for this alias
BaseFileName -- varchar The name of the file containing the base table
ModCount -- int The number of times this table's schema has been modified
Filemaker_Fields
TableName -- varchar The name of the table for this column
FieldName -- varchar The name of the field
FieldType -- varchar The SQL data type of this column
FieldClass -- varchar The type of field: "Normal", "Summary" or "Calculated"
FieldReps -- int The number of repetitions defined for this field
ModCount -- int The number of times this field's definition has been modified
Regards,
Micah
SQL field metadata?
Hello Gord,
Unfortunately, I don't think any type of metadata functions are supported. Check out the ODBC/JDBC documentation to get an idea of what IS supported:
http://filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
Regards,
Micah