Hi all

Got a problem and can't think of a solution (tried a bunch of things, nothing worked) and hope someone out there has been there and done that.

Problem

I have a field in a table defined as varchar, output lenght 11 with an output conversion of L######-##-#. (I have also used 9 as the output length.) There is no validation (default). In table builder, I did not define an output conversion or validation. When it is entered or in the table from converting the old AREV file, the number is in proper display such as 123456-ab-3. However, when the record is saved, the hyphens are saved with this field and when displayed after being saved are displayed as 123456–a-b.

Any one have any ideas on this?

I have the same type of problem with the key. It has a hyphen in the output conversion (I have changed it default when I found the problem). Once I figure out the problem with the table field, I'll have the key problem solved at the same time.

Thanks for your help.

Andy Becker

IL STATE LOTTERY

I've seen similar behavior with Patterns on Display if the dictionary atrributes are not set correctly. In my accounting apps, the Chart of Accounts ID is an integer, length 7, but is displayed as #-###-###. The Datatype is INTEGER(7), the Input Pattern Validation is 7N and the Output Patern is justified Right, mask #-###-###. This seems to work in all versions of AREV and in OI 3.71.

HTH

Don C. Miller

C3 Inc.

Thanks Don

I'll give it a try.

Andy

View this thread on the forum...