Re: arrrggghhh!! Select statements..

THIS DID IT. Can you explain if it isn't too much trouble why it does this?
I just want to understand instead of just following blindly.

And sorry about the font, yes it does look aligned here. I will keep this
in mind next time I have to do this again.



"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: ... 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: 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)
  • Re: Base Normal Form
    ... Gene Wirchenko wrote: ... but I was referring to "column ordering" and not row ... The RM operators need not act on the column ordering info, ...
    (comp.databases.theory)
  • 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)