2

I have to access a FileMaker DB via ODBC in a C# application...

When querying database table, everything goes fine. However when it comes to query a layout named XYZ for instance (as far as I understood, layouts are some sort of SQL views, please correct me if I am wrong), application throws an error indicating that _the table XYZ is not found_.

I wonder if there is any special keyword to access a layout in the odbc command or any other way to query layout via ODBC?..

I could not manage to find a source describing the accessibility of layouts via ODBC. I have a little knowledge about FileMaker, thus this question could be inappropriate, sorry for the inconvenience in advance.

Glory Raj
  • 17,397
  • 27
  • 100
  • 203
chicco
  • 147
  • 7
  • my two cents are that ODBC is a standard connectivity bridge/protocol which supports only common objects and methods which are mostly available in many different databases, these layouts you are talking about seem to be specific of Filemaker so could be the ODBC driver does not support them because it has no way to translate/transfer those objects in anything meaningful on the other side of the driver. I know nothing about FileMaker, just a guess. – Davide Piras Sep 20 '11 at 23:28

1 Answers1

2

You cannot access layouts via ODBC, only tables. Otherwise here's the manual (PDF) on FileMaker ODBC SQL.

Mikhail Edoshin
  • 2,639
  • 16
  • 25