Axapta and the great White Space Robbery

Along a similiar vein to this question, I'd like to store only white space in an Ax2009 table field.

...We want to be able to store " " (string containing one space or more) in a field (the field content is exported to a plain text file later on).

After an insert, the value remains " ", but if we do 开发者_运维百科a Select on the table the value is replaced by "".

Any suggestions? Thanks.

You can check the workaround used in standard AX for field AddressFormatLines.Separator

An additional field NumOfSpaces is used to overcome this AX limitation, methods insert, update, and postLoad are overridden accordingly, and as a result you can store a white space and also see it in forms (although you won't see it in SQL Server).

Sorry, but trailing spaces are removed. Live with it.

there is actually a way of storing a white space at the end of a string field. Instead of using the normal space bar enter Alt+255. That will create a space which is not removed.