abt field length

[shafee212]

there is a field having width as x(8) . But i have only option to store more than 8 characters in that fields . Can i do that May be i can convert that text into some coded form that of 8 chars or less and we can store it in the field , then we can uncode them and use them .

Is there any coding tecnique .

 

[sdjensen]

The value x(8) is only the default display format.
You can store up to 32K in the field regardless of the display format.

 

[tamhas]

Note that storing more in the field than the format can create issues with SQL. If that is an issue, use dbtool to set the SQL width to fit actual contents. But, you also might want to set the Progress format to fit the actual data ...