Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

SQL Statement - FROM??????


andrej27

This topic is 8398 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm a beginner with FileMaker - coming from an Access background (only intermediate in Access). I'm trying to execute an SQL statement from an external application and am having problems. Specifically, I'm not sure what to reference for the FROM statement. In Access, the FROM would reference the table.

Here's my SQL statement for FileMaker: Select Section FROM sesats WHERE Section = '3'

Section is the column in the FileMaker database. Currently I'm using "sesats" for FROM - that's the ODBC Data Source name.

What does FROM reference in SQL for FileMaker?

Thanks for any help you can give me.

Link to comment
Share on other sites

Filemaker is simply 1 table per file, so you would simply reference the ODBC data source name (i.e.SELECT * FROM fm_dbname WHERE section = 3 ).

I am by no means a SQL expert so I do not guarantee this, but this is what I have done in the past when working with Filemaker ODBC sources.

Link to comment
Share on other sites

This topic is 8398 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.