Re: SQL clause to check value

["Raul A. Jager W." <raul@xxxxxxxxxx>]

You can use this option, or the "case" option to create a view that you
can use as if it whas the file with the two new fields added (and always 
up to date).

Joe Pluta escribió:
> My bad, I thought you were updating the file for later use.
>
> For a query, the same thing works, though:
>
> SELECT MAX(AMOUNT, 0) AS DEBIT, MIN(AMOUNT,0) AS CREDIT
>
> Sorry about the confusion...
>
> Joe
>
> > Piece of cake.
> >
> > UPDATE MYFILE SET
> >    DEBIT = MAX(AMOUNT,0),
> >    CREDIT = MIN(AMOUNT,0)
> >
> > Your amount field is still intact, but your two new fields have either
> > zero or the appropriate amount (plus or minus).
> >
> > Joe