Still having problems with - "" table not available... (AREV Specific) [Revelation On-Line Wiki]

AREV Specific

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 OCT 2002 11:23:27AM John Jones wrote:

I first experienced this problem 3 weeks ago ang posted the following-

I'm running AREV 3.11 on a Windows 98 machine (for 3 years) and suddenly I get the following error message - The "" table is not available FS 200… The message appears when I try to search the database. I would like to delete the table but I can't seem to get a hold of it. Any suggestions?

I removed and rebuilt the index and also did a VERIFYLH (no errors reported) on the volume without any improvement in the situation. The index doesn't seem to work on the suspect table.

Any suggestions of what I should try next?

Thanks,

John

At 22 OCT 2002 05:14PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Remove indexes, then build a symbolic (in the VOC table) called DELIM that looks for delimiters or non-alphanumeric data in the keys. A simplified version of this formula might be along these lines:
ANS=0
ALLOWED.CHARS =@UPPER.CASE:"0123456789":"*_-."
FOR K=1 TO LEN(@ID)
  THIS.CHAR=@IDK,1
  IF INDEX(ALLOWED.CHARS,THIS.CHAR,1) THEN
    ANS += 1
  END
NEXT K
IF ANS=LEN(@ID) THEN
  ANS=0
END  
RETURN ANS
Then at TCL

LIST anyfilename WITH DELIM 0 DELIM

If you see record keys listed in the report then these are potentially corrupting your reindexing. Remove these and re-apply the indexes. You should ensure that there is sufficient RAM in your session to enable this. 250K+ from the WHO window is usually OK.

Steve

The Sprezzatura Group

World Leaders in all things RevSoft

At 23 OCT 2002 06:15AM Hippo wrote:

This code can be shortened and speeded up using

COPY_ID=@ID

CONVERT ALLOWED.CHARS TO '' IN COPY_ID

RETURN COPY_ID='

At 23 OCT 2002 06:27AM Steve Smith wrote:

Thank you for that additional clarification. We suspect you meant

Return (Copy_Id#"")

or

LIST anyfilename WITH DELIM=0 DELIM

Otherwise you would gather all of the keys without errors. We realise

the () are optional but when using boolean comparators we like to

clearly mark them as such.

The Sprezzatura Group

World Leaders in all things RevSoft

At 24 OCT 2002 07:02AM Hippo wrote:

Yes you are right, sorry, I negate the logic.

I have nothing against parenthesis:)

At 24 OCT 2002 08:43AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

Whilst having nothing against parentheses we think the curly braces have a certain nous ne savons pas …

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...