<br>- error messages: <br>We use a table and an auxiliary screen to show the messages. <br><br>- screen titles, field and other labels: <br>We use a table. All the titles and labels are temporary fields filled in the INITALIZE. For reports, we use QTP to create an auxiliary subfile with all the titles and headings.
<br>If temporary items could be used as field's labels we would save time and lines of code, but I realize that this can be difficult to add.<br><br>Our dictionary is in Spanish and we use tables and auxiliary screens for field's helps, description of the screen....
<br><br>We don't use CC. When we develop, we write the record in Spanish. If a record hasn't got translation is shown in Spanish. Some users have access to screens in which they can write the translation of error messages, labels...
<br><br>- function key labels<br>Not dealt with yet<br><br>- menu labels and menuitem labels<br>Not dealt with yet<br><br>- month names (from the dictionary)<br>We use Spanish ones. If necesary we obtain the translations from multilanguage tables.
<br><br>- decimal character (from the dictionary)<br>We use ',' for decimal positions, but some functions as FORMATNUMBER doesn't work.<br><br>- numeric item formatting<br>We use ',' for decimal positions: PIC "^^^.^^^.^^^,^^", but we convert numeric fields to char in order to show decimal points when we send data to english clients or providers.
<br><br>- date formatting<br>We always use DDMMYYYY date format. When exporting data to Excel, we use YYYY/MM/DD.<br><br>- collating sequences (if the data is non-English)<br>Not dealt with yet<br><br>- upshift/downshift sequences (if the data is non-English)
<br>This line in the dictionary solve our problem with latin characters, but we haven't dealt with the Polish ones yet.<br>ASCII8 CHARACTER SET Upshift Ascii "áÁàÀâÂéÉèÈêÊíÍìÌîÎóÓòÒôÔúÚüÜùÙûÛñÑçÇ"<br><br>We also have a problem with Oracle. Our database is UTF8 and the field size shown by the dictionary isn't real:
<br><br>Oracle table definition:<br> ENTIDAD_OFICINA VARCHAR2(8 BYTE),<br> COD_POSTAL_BANCO VARCHAR2(10 BYTE),<br> NOMBRE_BANCO VARCHAR2(30 CHAR)<br><br>QSHOW:<br>Item Type Size Occ Offset
<br>ENTIDAD_OFICINA VARCHAR 10 0<br>COD_POSTAL_BANCO VARCHAR 12 20<br>NOMBRE_BANCO VARCHAR 122 32<br><br>We have to use the size option in all the field declared in Chars instead of bytes, Nvarchars,...
<br>