AnsweredAssumed Answered

ODBC SQL Syntax

Question asked by GermaineThomas on Mar 10, 2014
Latest reply on Mar 21, 2014 by nilsw

Summary

ODBC SQL Syntax

Product

FileMaker Pro

Version

13

Operating system version

windows 7

Description of the issue

I use a .net client to query Filemaker Pro to retrieve data and send to another system.  When I add my SQL query, I am unable to retrieve data; although my ODBC driver passes the test in the Microsoft Administrative ODBC window.

I've tried a regular SQL statement like Select * from Contacts_db

AND

EXECUTESQL ("select * from Contacts_db" ; "" ; "" )

Steps to reproduce the problem

Created database Contacts with table Contacts_db

Expected result

Two rows of data in database

Actual result

SQL syntax error

Outcomes