Re: Error 461 of Informix

>Does anyone see the ISQL Error 461 and ISAM Error 0 or -100? > >I ran a 4GL program that include the SQL statement that >retrieving a single row from the table, but that returns me >such error. That's fine if I using the ISQL to retreive the >same row. 461 is to do with BLOBs, and -100 is a duplicate value in a unique index. It's a pretty weird combination, especially from a SELECT. 1. Are you trying to select BLOBs? 2. Have you run oncheck -cDI lately? 3. Is there anything in your online message log? HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com