Hi Peter,
The message refers to data handling between the ODBC driver and your
database.
I would examine what values you are passing "in" to your database
search criteria (to get your search results). Either from an argument,
or are you using the memo field directly in a join?
Hope that helps.
Scott,
On Dec-20-2008, at 1:50 PM, Peter Fogg wrote:
Hello all,
If the memo field contains a "small" amount of data, the WiTango
search returns the data; if the memo field contains a "large" amount
of data, this message is returned:
"[Microsoft][ODBC Microsoft Access Driver] The field is too small to
accept the amount of data you attempted to add. Try inserting or
pasting less data. 22001"
I have not experimented to determine what "small" and "large" are
but my guess is less than or greater than 255 characters.
The message implies that I am trying to insert data too large for a
field but this is a search action. Does the message refer to the
WiTango search action default array, ResultSet, in which the results
is placed?
Thanks for any thoughts on this problem.
Peter -
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
