Re: Irritating sqr error

[the dragon <ceprn@HOTMAIL.COM>]

Jim,

Yes, I agree that someone was watching their tonsils when the designed the
databases, in more ways than one... However, keep in mind that if you are
ever dealing with a #variable# or $variable$ in a program, you have yourself
to blame.  It's very simple to change the name of a variable as it is
selected from the database - creating a &variable that won't cause problems
and then a $variable or #variable that doesn't cause problems.  No one ever
said you have to use the column name as a variable internally to the sqr.
Yes, this makes the code less confusing (in some cases), but it can also
cause processing problems.

begin-select

tbl.page#           &page_nbr
tbl.line#           &line_nbr
tbl.transit#        &transit_nbr

   let #page_nbr    = &page_nbr
   let #line_nbr    = &line_nbr
   let $transit_nbr = &transit_nbr

from ps_stoopid_over_normalized_table tbl  ! :-)
where 1 = 1
and   tbl.page = 67 ! don't know if this is number or character

end-select

clark 'the dragon' willis
dragon enterprises, consulting services

you wrote....
If only PS hadn't named all these fields page#, line#, transit#, etc etc
etc.

jim

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com