Error with SELECT - urgent!! (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 21 MAR 2001 11:33:15AM S Shavdia wrote:

AREV Specific

SELECT statement in my application is selecting same records twice as if it's existing twice in the table. If I do LIST at TCL it shows it correctly, listing only once. I cleared LISTS using CLEARFILE with no luck.(using AREV 2.12 on Novell)

Need urgent help!! Thanks in advance.

At 21 MAR 2001 11:46AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

Are you sorting BY a multi-valued field?

The Sprezzatura Group

World Leaders in all things RevSoft

At 21 MAR 2001 12:00PM S Shavdia wrote:

Thanks a lot for quick response. Actually I am sorting on a single value Symbolic field. I rebuild the index and it works!
Thanks.

At 21 MAR 2001 12:20PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

Glad you fixed it! You know that indexes on symbolics only work well if calculated from the current record (i.e. not xlated in from anothe file)?

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...