>Mark,
>Thanks for the tip.
>
>I am trying to update the view and it works great until I exceed 4000 characters. I get the message ORA-00997 Illegal use for long datatype. Do you know why I might receive this error? Have you successfully updated a view with more than 4000 characters?
>
>Matt

I have no trouble updating LONG data type with VFP memo. What ODBC driver are you using? I use the MS ODBC for Oracle. Get my Oracle_DSN class from UT Downloads for help with DSN or DSN-less connections to Oracle.