Re: 245 Could not position within a file via an index

Allan Gould <allang@visionware.co.uk> wrote in article <55aqr6$l36@avon.sco.com>... > Title: 245 Could not position within a file via an index. > > Error: > > 245: Could not position within a file via an index. > 103: ISAM error: illegal key descriptor (too many parts or too long).> > Has anyone got any idea why I might get this error from a stored procedure > when I execute it, yet when I execute the query "hands-on" it runs fine?? Try running update statistics for procedure <procedure-name>. Remember that the statements are optimized when the procedure is created and does not reflect any changes you make to your database afterwards. Alternatively, you can drop the procedure and re-create it.