Jump to content

ODBC Limitations


eddyb2

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

Recommended Posts

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

Link to comment
Share on other sites

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