ODBC Limitations

September 20, 200619 yr

Hi all,

I have just started using ODBC to send data from Excel to a fileMaker server. Everything was working great until i stumbled upon what I think are a few limitations.

FileMaker documentation states that you can SELECT up to 170 fields at one time from a FileMaker file and can UPDATE up to 100 fields at a time.

All was working fine until my database table went over 89 fields.

At 89 fields

SELECT * FROM works well and you can sleect all the fields from the database and go on to update them

At 90 and over fields you receive an ODBC error against this line.

So I tried splitting my select and update code up into sections so it would only receive a certain number of fields at a time rather than the whole lot.

But again I hit a limitation. When specifying the fields in your SELECT statement ODBC reports an error after 8 fields are specified.

Has anyone else experienced these limitations and do you know a workaround.

Is the FileMaker documentation incorrect?

Many thanks