Re: arrrggghhh!! Select statements..

Yeah I inheritted this program and it does have a bunch of old code in there.
Probably why I sometimes have a hard time finding proper help on stuff.
Looking up outdated crap. :))

Thanks.



"Anders Altberg" wrote:

Note also the BETWEEN(date, sdate, edate) is an Xbase function. The SQL
version is
date BETWEEN sdate AND edate
Both work in VFP but as soon as you start communicating with other SQL
databases, only the SQL version works.

-Anders

"Emily" <Emily@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7052B481-FCD0-4F47-B45F-46F3726E3264@xxxxxxxxxxxxxxxx
OH THANK YOU VERY MUCH



"Gene Wirchenko" wrote:

Emily <Emily@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am not sure why I can't get my select to work.

this is what I am doing

select *,pmt_date as pmtdate from payment ;
where payment.pmt_date between sdate and edate
order by invo_num into dbf (dir_temp+'temp1.dbf')

select * from temp1,invlines ;
where temp1.invo_num=invlines.invo_num into dbf
(dir_temp+'temp2b.dbf')

This is doing what you tell it to. When invo_num matches,
select.

I am guessing that your where clause expression should be
temp1.invo_num=invlines.invo_num and
temp1.rptrnum=invlines.rptrnum

[snip]

invlines looks like this

invonum linenum rptrnum product amount
100 1 15 a $50
100 2 15 b $150
100 3 29 c $500
100 4 29 d $200

It would be easier to read if the columns lined up. They might
for you; they do not for me. Using a fixed-width font is best. I
almost gave the wrong columnname, because 15 looks to be under
product.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.




.

Relevant Pages

  • Re: arrrggghhh!! Select statements..
    ... "Gene Wirchenko" wrote: ... invonum linenum rptrnum product amount ... Using a fixed-width font is best. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: arrrggghhh!! Select statements..
    ... where payment.pmt_date between sdate and edate ... order by invo_num into dbf ... invonum linenum rptrnum product amount ...
    (microsoft.public.fox.programmer.exchange)
  • Re: arrrggghhh!! Select statements..
    ... "Gene Wirchenko" wrote: ... where payment.pmt_date between sdate and edate ... invonum linenum rptrnum product amount ...
    (microsoft.public.fox.programmer.exchange)
  • Re: arrrggghhh!! Select statements..
    ... Gene was right - I didn't have too much time to analyze the select but you ... order by invo_num into dbf ... invonum linenum rptrnum product amount ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Base Normal Form
    ... will not get it in any particular order unless you specify the order. ... If it does matter, then specify the ... Gene Wirchenko ...
    (comp.databases.theory)