Re: VFP9 SQL Query Column Width Bites Again!

Jeroen van Kalken <I@[EMAIL PROTECTED]
> wrote:

>On Thu, 08 May 2008 14:08:56 -0700, Gene Wirchenko <genew@[EMAIL PROTECTED]
>
>wrote:
>
>in VFP9 you can also use the CAST function to get the right amount of
>digits; making it slightly more readable/understandable.
>Like:  Cast(nvl(pcl.cpcl,0) as n(10,1))

     This is getting messier.  It appears that I will be adjusting a
lot of code.

     Is case() ever necessary when a column is being used directly?
i.e.
          select thiscol,thatcol from ...
I am hoping that such usage is always safe.

Sincerely,

Gene Wirchenko

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