General information
Category:
Coding, syntax & commands
Title:
Queries formating variables
>[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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only