Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!mintaka!think.com!sdd.hp.com!elroy.jpl.nasa.gov!ames!uhccux!bigtuna!pegasus!tleylan From: tleylan@pegasus.com (Tom Leylan) Newsgroups: comp.databases Subject: Re: Clipper 'S87 TYPE MISMATCH Keywords: TYPE MISMATCH Message-ID: <1991Jan30.094848.6304@pegasus.com> Date: 30 Jan 91 09:48:48 GMT References: <1991Jan25.031035.4546@micor.OCUnix.On.Ca> <1991Jan28.125745.19241@pegasus.com> <1991Jan28.233729.10049@micor.OCUnix.On.Ca> Organization: Pegasus, Honolulu Lines: 12 In article <1991Jan28.233729.10049@micor.OCUnix.On.Ca> mcormier@micor.OCUnix.On.Ca (Michel B. Cormier) writes: > >However, I still don't understand why the SELECT 8 was working even with >the file being closed... Am I missing something??? > Michel, Just luck I guess... obviously SELECT 8 is impervious to the missing ALIAS problem but why the file was opened there ... it's possible that you had the file opened twice. Once in the "real" area where you used it all the time and accidentally in workarea 8. You might take a moment and see if the file is opened in more than one area just for kicks. tom