VFP9 SQL Query Column Width Bites Again!

#91

Gene Wirchenko wrote:

Quote:

Jeroen van Kalken <I (AT) dont (DOT) like.spam> wrote:

On Thu, 08 May 2008 14:08:56 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net
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.

Yes, a single column should be safe. They'll always all be the same width,
by definition.

Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

VFP9 SQL Query Column Width Bites Again!

comp.databases.xbase.fox comp.databases.xbase.fox

Re: VFP9 SQL Query Column Width Bites Again! - 05-09-2008 , 10:43 AM