FOC1130 what went wrong with the format conversion?

[kaeserea]

Hello!

In my Master File Description I have defined the following field:
[tt]
FIELDNAME=SUM ,ALIAS=SUM ,
USAGE=I007 ,ACTUAL=P013 ,
DESC='SUM ',$
[/tt]

And I receive the error FOC1130 (Format conversion error).

Can anybody tell me what goes wrong in converting the P013 format to a I007 format?

Thanks a lot
Eva

 

[kiddpete]

Try I7 and P13. Focus doesn't really use leading zeroes in formats. BTW, you are going to have no end of trouble with that field name. SUM is almost certainly a reserved word, and Focus is going to have a devil of a time trying to figure out what you are talking about.

 

[gizzy17]

Leading zeros are should not be an issue in the master file description, but as kiddpete stated SUM as a field name (or alias) will cause you many headaches. Change the field name/alias to something like SUM_FLD and you should be OK

SUM is a verb for a table request.

 

[kaeserea]

Hi!

The leading zeros are no problem. I use them with character fields as well. But I now found the solution to the problem. I had an old data description that was used with RAMIS (another programming language that is similar to WebFocus). And P13 in RAMIS is P7 in WebFocus. A collegue told me the thumb rule is
[tt]
(Packed RAMIS format + 1) / 2 = Packed WebFocus format
[/tt]
ok, SUM... I know what you mean. I now use a different name. Thanxs a lot.

Eva