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

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

Recommended Posts

Posted

Hello everyone, I'm working with a 3rd party software that is sending query over ODBC in what I think is some sort of ANSI mode example:

SELECT "Age","Last Name","First Name","DOB","Sex","MI","Height","Weight","ID1","ID2" FROM Demographics

I was wondering if there is anyway for FMP to accept this type of query?

I know in MySQL you can run in a ansi mode which will treat the "" as idenitfiers not as a string.

Right now the result of that statment looks like this:

"Age" "Last name" "First name"

Could someone please point me at the right direction.

Thank you

This topic is 7394 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.