This feature does not work when the string field and the linked integer field are in a scrolling window. This is a known issue. This issue is documented in Microsoft Knowledge Base article 869310. For more information, see the "References" section. This article describes how to use multiple string formats in a scrolling window by using Dexterity in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.
- Create a new local string field of a keyable length that is large enough to fit the longest format.
- Put this local string field in the scrolling window, and then hide the original string field.
- Create a series of messages that have an ID that is larger than 22,000 and that contains the formats in the same order as they are listed in the format string list. If you begin at message 22,201, the base number will be 22,200.
- Create a Format_String function that resembles the following.
function returns string OUT_String;
in string IN_String;
in string IN_Format;
local integer i, j;
local string l_string;
clear l_string, j;
for i = 1 to length(IN_Format) do
if substring(IN_Format,i,1) = CH_X then
l_string = l_string + substring(IN_String,j,1);
l_string = l_string + substring(IN_Format,i,1);
OUT_String = l_string;
- In the Scrolling Window Fill script, set the local string field by using the Format_String function. Note You must use the fields from the table buffer because the window fields are populated after the fill script is completed. This will format the local string field as if the multiple formats were working.
'(L) Dummy String' of window Scrolling_Window =
Format_String('String' from table Table, getmsg(Base + 'Format' from table Table);
If the local string field must be editable, you can use the field PRE script and the POST script to strip out the format, and then add it back later. This would make the local string field behave in a similar manner to how date fields work.
Id. de artículo: 949623 - Última revisión: 17 ene. 2015 - Revisión: 1