Character 'E' in record key caused xref work strange (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 22 AUG 2007 06:41:47AM RICHARD NG wrote:

AREV Specific

i have few hundred record in a table, and xref index the name column
for the table.  
when xref searching, it not return all records which is meet the
searching criteria.
it seems all the record key with character 'E' treated as numeric
and not return properly in searching.
eq: 210E-100 Is consider as numeric instead of text.

(E means exponential in this case ??)

please advice how to solve this problem.

thanks

At 22 AUG 2007 09:27AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Put a custom conversion that prefixes an "X" onto the string.

The Sprezzatura Group

World leaders in all things RevSoft

View this thread on the forum...