DAO.QuaryDef and Memo fields...HELP!!
may be not exactly what you search for : take a look to Getchunk/AppendChunk
methods to get/set long fields.
2 things :
1. r u sure about the use of '?' char which may conflict with like operator
2. how do you affect parameters when executing the query ?
Phil Hodey a crit dans le message
Quote:
>I am trying to use a DAO.QuaryDef object to update a table (.mdb) which
>contains memo fields. I have ensured the parameter type is dbMemo (12) but
>it will not work on strings longer than 255 characters. I thought the
dbMemo
>type accepted long strings (ie longer than 255 chars). Is there a bug, or
am
>I doing something wrong?
>The sql is...
>PARAMETERS [?OtherComments] LONGTEXT, [?ClientID] LONG;
>UPDATE Client SET OtherComments=[?OtherComments] WHERE ClientID=[?ClientID]
>It works in VisData, but breaks when I create the querydef in code.
>Any suggestions?
>TIA
>--
>Phil Hodey
