SQL and Memo fields

[denis.dougall]

I recently converted acc97 to acc2002 and when the form tries to call from a
select * command it fails (ORA602) when I list the fields and exclude the
memo field it completes the call. When I query the linked table for the memo
field and a few other items, it is successfull. Does this sound like a DB
size issue? A corrupt DB? Any suggestions would be appreciated.

Thanks in advance,

Denis

PS I originally posted this question in the import/export forum, I thought
it may belong there.

 

[Sylvain Lafontaine]

Maybe a reference problem or something like that: try to create a new and
empty A2002 db and then import all of your stuff into it.

You can also try to explicity name all the fields (instead of using the
operator *) with a special consideration for the memo field by putting it in
the last position.

S. L.