Newsgroups: comp.databases
Path: utzoo!utgpu!cunews!micor!mcormier
From: mcormier@micor.OCUnix.On.Ca (Michel B. Cormier)
Subject: Re: Clipper 'S87 TYPE MISMATCH
Organization: M.B. Cormier INC., Ottawa (Ont)
Date: Mon, 28 Jan 91 23:37:29 GMT
Message-ID: <1991Jan28.233729.10049@micor.OCUnix.On.Ca>
Keywords: TYPE MISMATCH
References: <1991Jan25.031035.4546@micor.OCUnix.On.Ca> <1991Jan28.125745.19241@pegasus.com>

In article <1991Jan28.125745.19241@pegasus.com> tleylan@pegasus.com (Tom Leylan) writes:
>In article <1991Jan25.031035.4546@micor.OCUnix.On.Ca> mcormier@micor.OCUnix.On.Ca (Michel B. Cormier) writes:
>>
>>I have a routine that basically does a SELECT JUNKY (the databases are all
>>opened a long time before) followed by some more works.  This routines works 
>>MOST of the time.  In one particular instance however I get a 
>>TYPE MISMATCH ERROR on the select statement.  Changing that particular 
>>SELECT to SELECT 8 makes the problem vanish.  Also, marking at least one 
>>record as non-deleted (which I don't want to do) solves the problem.
>>
>Michel,
>
>It has to be something major that is in your code since it isn't caused
>by anything Clipper is doing wrong.  For the most part you will want to
>always reference a file by it's alias.  The only reason I can see that
>you lose an alias is that the file got closed somehow.  Could it be that

You got it!  I had time to trace thru my code today and found this awful
CLOSE statement lying in the middle of my code.  Of course, once the file
was closed, the alias was not working anymore.  I still don't remembering
putting that CLOSE statement there but I'll take the blame for this one.

However, I still don't understand why the SELECT 8 was working even with
the file being closed... Am I missing something???

Thanks also to the other suggestion I received by mail.

MBC
-- 
Michel B. Cormier              | UUCP: mcormier@micor.uucp
Computer Consultant            | Internet: mcormier@micor.OCUnix.On.Ca
DOS/Unix/MPE V/MPE XL          | BBS:   (613) 237-5077
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=