>I am using the CA class and have a strange thing happening.
>
>I use CursorFill to create a cursor that is basically a parameterized view. I edit a Memo field in my cursor and issue a TABLEUPDATE.
>
>The next time I issue a CursorFill() the memo comes back as empty. It does this for all subsequent CursorFills even if the parameter is changed to a different key, even if I close the cursor, and even if I completely release the CA object and create a new one.
>
>However if I do another query on the table using SQLEXEC() the next time I issue a CursorFill the updated memo field is returned. I can add a small Select command in the AfterUpdate() but it is not an ideal solution.
>
>This could be another DB2 oddity.
Hi Patrick,
CursorAdapter might be responsible for this behavior. Take a look into message #
890123 for a possible workaround.
Thanks,
Aleksey.