>>>>Hi Tore
>>>>
>>>>Nice to see other than me online.
>>>>
>>>>Are you any good at SQL? cos I sent this message yesterday and I can't figure why my SQL was working fine but now just selects all, or many, operators
>>>>
>>>>Message #
1141384>>>>
>>>>I'd really appreciate any help, and I'm going round lately cap-in-hand, as I need to get this finished before tommorow of I don;'t go on holiday (all booked)
>>>>
>>>>Cheers
>>>>
>>>>Terry
>>>
>>>Is this "real" SQL or VFP SQL? If it's "real" SLQ, I have to pass, since I only have experience with VFP SQL.
>>
>>No VFP (7) SQL :-)
>
>Well, at least I see that the Between syntax in the Where clause is incorrect:
>And (ET.date BETWEEN ldStartCurr and ldEndCurr ;
> OR ET.date BETWEEN ldStartPrev and ldEndPrev)
No, this is legal VFP SQL Between, as opposed to the VFP BETWEEN() function. This is not the problem. The dates are never null AFAIK :-)
>Should be something like
> And (between(ET.date,ldStartCurr,ldEndCurr) ;
> OR between(ET.date,ldStartPrev,ldEndPrev))
>What happens if ET.date is empty or NULL?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.