Format command and .STX error

bbrown

I have tested the 3 following statements:

1. FormattedValue := FORMAT(SetField,0,1);
2. FormattedValue := FORMAT(SetField,0,'<Standard Format,1>');
3. FORMAT(SetField,0,'<Sign><Integer><Decimals>');

The value of SetField = 1.99.

I expect all 3 statements to return the same result.

Statement 1 works. Statements 2 & 3 return the following error:

"There are errors in the text conversion (text no. 102-2026 does not exist in the .stx file).

Internal error:47-1

I am running 4.0 SP1 (local DB). I am local admin and also tried replacing the fin.stx from CD.

Savatage

http://www.microsoft.com/communities/ne ... 55909f5df2

bbrown

It appears that format strings do not work with datatype VARIANT. Converting the value to datatype DECIMAL (EVALUATE) before calling FORMAT resolved the issue.