Author: Matthew Jarvis
Posted: 2000-03-31 at 12:12:26
charset="windows-1252"
Do you have CDX tags for all the join conditions i.e. Revdata.disdat,
Hret98.disdat, Revdata.mrecno, Hret98.mrecno, Revdata.hospnm, Hret98.hospnm,
Revdata.ptctln, Hret98.ptctln and Revdata.hcfa_cc ?
That's where I would start....
mj
> -----Original Message-----
> From: NICOLE MORTELLO [mailto:NMORTELLO@njha.com]
> Sent: Friday, March 31, 2000 9:16 AM
> To: Multiple recipients of ProFox
> Subject: Re: VFP5.0 - SQL error creating a view
>
>
> I found the error, two fields that should have been the same
> type were not so I fixed it. Now what I want to know is
> there a better way to write this SQL so that it does not take
> so long? I am dealing with a lot of data (one file has
> 170000+ records, the other has 1.4 million records.) It has
> been running for about 5 minutes and seems to take over my
> computer. I do have limited hard drive space on the drive I
> am using. Can this be the cause of the slow processing?
>
> Nicole
>
> >>> "NICOLE MORTELLO" <NMORTELLO@njha.com> 03/31 12:06 PM >>>
> Hi All,
>
> I am trying to create a view with the following code:
> SELECT Revdata.revcode, Revdata.hcfa_cc, Revdata.dutnum,
> Revdata.cnttot,;
> Hret98.flag93;
> FROM hret!revdata INNER JOIN hret!hret98;
> INNER JOIN hret!revdata;
> INNER JOIN hret!revdata;
> INNER JOIN hret!revdata ;
> ON Revdata.disdat = Hret98.disdat ;
> ON Revdata.mrecno = Hret98.mrecno ;
> ON Revdata.hospnm = Hret98.hospnm ;
> ON Revdata.ptctln = Hret98.ptctln;
> WHERE Revdata.hcfa_cc <> "TOT";
> ORDER BY Revdata.revcode, Hret98.flag93
>
> This code is from the View Wizard, I am not very good with
> SQL yet so I still use the wizard a lot. I get a message
> data type mismatch. Can someone tell me where?
>
> The view is supposed to take two file and pull all from the
> first file except if HCFA_CC = "TOT" and one field from the
> second file if the HospNm, Ptctln, MRecNo and DisDat are the
> same in the two files. The first file can contain multiple
> occurrences but the second file should only contain one occurrence.
>
> TIA
> Nicole
>
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
>
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
>