MEMO field errors when running SQL filter -

I keep getting this error when i filter through a SQL server

<font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>error '80040e21'</font>
<p>
<font face="Arial" size=2>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</font>
<p>

this only occurs when I run it as a filter. when I ask for all records, the results return fine.

this is only on memo fields, nothing else. is there any other field type for SQL that might be better to use? This originally did work correctly using an access mdb.

thanks macaroni

Hi Mac,

Kind of an elusive problem, but easy to fix. Simply select your recordset
from the Server Behaviors tab (not the databindings tab), then down in the
Properties Inspector for that recordset, set the cursor location to
"Client". That should take care of it.

If that doesn't work, try moving the memo/text field to the end of your SQL
query:

SELECT field1, field2, memofield FROM myTable

Best regards,
Chris

That seems to have fixed the issue..... talk about confusing. i've had sql dba's looking into this and they told me i couldn't use memo field... that was not an option.... thanks very much.....
Mac passes Chris a beer.