eddyb2 Posted September 20, 2006 Share Posted September 20, 2006 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 More sharing options...
Recommended Posts
This topic is 6563 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 accountSign in
Already have an account? Sign in here.
Sign In Now