Re: SQLCODE and ISAM errors

Pete Smith wrote: > > I have a problem with a program failing every time it runs. > The sql error code is -264 ( Could not write to a temporary file. ) and > > the ISAM error is -100 ( duplicate value for a record with unique key ) > The esql query is of the form "update table set col=value where current > of cursor" > > It is not clear to me how these errors are related. My feeling was that > you might reasonably get one or the other error but not both at the same > time. > > can anyone shed any light on this? > > many thanks in advance > Pete > email: pete.smith@aethos.co.uk That's the normal way it works: ISAM reports a duplicate and disallows the update and SQL reports that it could not write. It's a clunky combination of messages but it does tell you what's happening. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.