>>[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
Select .... Planven.horaext/3600+0.0000000 as Value_hours_pay.....
Edward Pikman
Independent Consultant