You're welcome Peter,
> BTW why does describing a problem to someone else
> so often turn on a light bulb over one's head??
Because it forces you to look at the problem from another perspective.
Always glad to help, even subconsciously ;-)
Scott,
On Dec-20-2008, at 2:26 PM, Peter Fogg wrote:
All I am asking the search to do is return the record id and the
contents of the memo field of all the records in the table. The memo
field sorted alpha asc. There is no criteria specified, just get the
data form every record in the table. BTW, that the memo field has
some entry in every record.
Well, after writing the above paragraph, I decided to try something
that I hadn't tried before - I removed the "Retrieve distinct rows
only" requirement from the search action Voila! The search works
correctly!!
Thanks very much for you response and BTW why does describing a
problem to someone else so often turn on a light bulb over one's
head??
Peter -
On Dec 20, 2008, at 9:58 AM, Scott Cadillac wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
