Re: arrrggghhh!! Select statements..

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: ... 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: arrrggghhh!! Select statements..
    ... "Gene Wirchenko" wrote: ... invonum linenum rptrnum product amount ... Using a fixed-width font is best. ...
    (microsoft.public.fox.programmer.exchange)