> Man I got myself in more trouble screwing around. I'm playing with a
> small DB and I'm getting the following error:
>
> Application: basicData
> Error: EOGeneralAdaptorException
> Reason: Exception occured while evaluating 'saveChanges', on
> target:<Main 0xaca1c0>: SQLBindParameter in -[ODBCNumberColumn
> bindAttribute:forInputColumn:ofStatement:] S1004-0: [Microsoft][ODBC
> Driver Manager] SQL data type out of range
>
> the database is simple text fields and the data I'm trying to pass is
> simple, simple so I'm not sure why it would be out of range.
I got this exception myself a few days ago; my MS SQL database had
a field of type "int identity" (in EOModeler). The typeInfo dictionary
does not specify this kind of type, so EOAccess used the default type
for binding, namely a string. Therefor I got the exception quoted above
when trying to qualify for that "int identity" attribute.
My solution was (in program code, not in EOModeler) to get the model,
get the connection dictionary, get the typeInfo dictionary and then
copy the entry named "int" to "int identity" and set the new connection
dictionary in the model. Works for me. (You should do this before EOF
opens a channel to the database.)
Matthias
