It is my understanding that the fields on the SQL side of the fence typically have a specified length. I believe that I read somewheres that you need to specify a corresponding maximum number of characters for the FileMaker field on the Validation tab in Field Options. (I going by incomplete memory here so apologies in advance if I am getting this wrong.)
I'm still having issues, but this was still very helpful.
I am now able to bring fields over that are 'text' after adding a max legnth under validation.
However, my table also has calulation fields that just lookup text from another table and I do not find a way to add a ma length to those fields.
I have tried adding a max length to the orignal field on the table it is looking up from, and this does not work either.
I am sadly unable to query from the original table because there is over 400 columns, many of which are calculations, and many rows which causes it to take 30+ minutes to do a simple sql query. Having a table that just does lookups for only the data I am required to have seems to solve the speed issue, but I can only seem to get numbers and dates that way.
Thank you for the help =)
I'm assuming you are using Filemaker as the ODBC source file? No help, I'm afraid: but just a bit of empathy: I tried that with FM9 a few years ago. Was so incredibly slow that I thought it just had to be my fault. Like: query a table of 100 records for an expected result of 5, and watch it chunter through Progress Bars of 1000's of records. One. Record. At. A. Time. FM's total lack of help strongly suggested 'Actually, that's the way it is...'.
I dearly wish someone would reassure me that FM Server as an ODBC source now works acceptably.
Yup, I'm using FileMaker as the ODBC source =(
To set the needed limit on a calculation field, you might try using a text field with an auto-entered calculation.