unfortunately, the original developer of our app did store VO arrays into memo fields. ( Using AdsSetField( ... ) )

I am copying data from one table to another, using a stored procedure. Basically a

insert into abc ( memocol ) select othermemocol from xyz

this was working fine, at least with ADS 9

Right now, with ADS 10 and 11 I am getting errors 5154 "..... Memo field contains binary data "

Has something changed in this area?

Thanks Oskar

asked 06 May '13, 09:36

Oskar's gravatar image

accept rate: 18%

This behavior changed in 10.0 when we added unicode support. The problem is that one field is MEMO and the other field is BINARY. Make sure the field types are the same or use the CONVERT or CAST scalars to convert the field data before inserting it.


answered 07 May '13, 08:44

Peter%20Funk's gravatar image

Peter Funk
accept rate: 32%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 06 May '13, 09:36

Seen: 1,616 times

Last updated: 07 May '13, 08:44

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.