Message 250 (AREV Specific)
At 02 MAR 2001 09:40:50AM Roy Drummond wrote:
Hey y'all,
I am getting the following message (#250) "The row QUICKDEX.MFS in file DICT.MFS is over 64K bytes limit for updating relational indexes. Relational indexes for this row will not be updated."
I do not have a file DICT.MFS and have not been able to find a bloated Quickdex.
Any suggestions.
Roy
PS Could this have something to do with the RELATER problem that I have posted previously and that we are still having problems with.
—————————–2227656246941–
At 02 MAR 2001 09:47AM Mike Ruane wrote:
Roy-
One of your files that has a Quickdex or Rightdex has exceeded the 64k limit in the %records% record. Find the file and remove the quickdex or rightdex.
We're working on the relater problem.
Mike
At 05 MAR 2001 10:15AM Roy Drummond wrote:
Is there any way to determine which one? This system has a bunch of files, directroies, etc., etc.
Roy
At 05 MAR 2001 10:47AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
You could break to the debugger and check the contents of @ID.
You could also run a program on the file to find all the records in the file that are approching 64K.
Some versions of ARev have a SIZE symbolic in the dictionary. If yours does not, you can easily create one.
@ANS=LEN( @RECORD )
From TCL then you can
LIST FileName WITH SIZE ] 62000
World Leaders in all things RevSoft
At 06 MAR 2001 03:11AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Actualy thinking about it this seems to be a red herring. Message 250 IS called from RELATER and it relates to the fact that the destination record has become too big. So check all files with relational indexes. The dict.mfs/quickdex message is probably a corruption in some way.
World Leaders in all things RevSoft
At 06 MAR 2001 11:11AM Roy Drummond wrote:
Thanks for the suggestion. Next time we get the error I will check @ID. Till then I will check my sizes.
Roy