>[From: Anderson Reis Girardi]
>
>
>
>Hello all
>
>I wanna do a query where the output record must be formated, by sample.
>
>in table planven i have a field named nhoraext, it have the following format:
>numeric, 7.2, and i need the output record that will be a memory variable it must have seven (7) decimals digits.
>
>by sample 2/3600 = 0.0005555 and not like the vfp does to me 2/3600 = 0.00
>
>I'm using the follow sintax:
>
>SELECT Horas_util.codigo, Ncadcli.nome, Planven.nhoras, Planven.mensal,;
> Horas_util.username, Horas_util.total_segundos, Planven.horaext,;
> Planven.horaext/3600 as Value_hours_pay;
> FROM netone!horas_util, netone!ncadcli, netone!planven;
> WHERE Horas_util.username = Ncadcli.username;
> AND Planven.codplan = Ncadcli.codplan;
> ORDER BY Horas_util.username
>
>
>Thanks
>
>
>Anderson R. Girardi