ANSI mode?

[setowmich]

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 switch it to a ansi mode.

Thank you

[Lee Smith]

Hi setowmich,

I don't know that ANSI is, do you mean ASCII?

What you have is a Comma Separated Text and you have two choices.

If you already have a database established, then it will import into it (see below). If this is to be a new Database, it will help you create it (see below).

Start by Opening FileMaker and noting where the file is located on your Disk.

New Database:

In FileMaker, Go to - [color:"red"]Menu >> File >> Open. Next, you will see a Open menu that has "Show" and a Drop Down menu, with up and down arrows beside it. Select "Comma Separated Text File", and then locate your file, and hit the "Open" button.

It will create a New Database File and the name it using the Text File Name plus Converted. You can rename by typing over it.

Import:

Open your existing file, and Go to - [color:"red"]Menu >> File >> Import >> File. You will get a box similar to the one for Open, that you can Select from the "Show" menu, the Comma Separated Text. You will then get a second Box showing the Fields of your Text or Import File on the Left, and the Fields in your Database on the right. You need to line them up so that the populate your database correctly.

HTH

Lee

:(

[setowmich]

Thanks for the reply, in MySQL I guess ANSI changes the behavior of sql statments (check out the following link). http://mysqld.active-venture.com/ANSI_mode.html

The query statment above is from a 3rd party software which talks to a database (in this case FMP) over ODBC. The purpose of the select statment above is to list a list of users, it is not a text file. The reason I want to see if i can run FMP in an ANSI mode so it will treat "age" as a field, treating "" as idenifiers. Right now it treat "age" as the a string age, I want it to return a number. I'm hoping theres a ODBC translator out there somewhere.

Thanks again Lee

Joe

[Lee Smith]

hi Joe,

Sorry to have missed your question totally. I guess I was confused by the fact that you posted it here in FileMaker Functions & Features >> Importing & Exporting, rather than someplace like Publishing FileMaker Online >> ODBC / JDBC.

I have no interest in SQL, ODBC, etc. so ANSI is not a term I'm familiar with. Hopefully one of the Experts in this type of thing will read this and give you some assistance.

Lee

[setowmich]

yeah I should of posted in odbc sorry.

lee