{{tag>category:"AREV Specific"}}

[[https://www.revelation.com/|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]]


==== Still having problems with - "" table not available... (AREV Specific) ====
=== At 22 OCT 2002 11:23:27AM John Jones wrote: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

<QUOTE>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:


<code>

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

</code>




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



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 23 OCT 2002 06:15AM Hippo wrote:  ===

<QUOTE>This code can be shortened and speeded up using

COPY_ID=@ID

CONVERT ALLOWED.CHARS TO '' IN COPY_ID

RETURN COPY_ID='

</QUOTE>

----

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

<QUOTE>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.





[url=http://www.sprezzatura.com" onMouseOver=window.status= Click

here to visit our web site?';return(true)]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 24 OCT 2002 07:02AM Hippo wrote:  ===

<QUOTE>Yes you are right, sorry, I negate the logic.



I have nothing against parenthesis:)

</QUOTE>

----

=== 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:  ===

<QUOTE>Whilst having nothing [i]against[/i] parentheses we think the curly braces have a certain [i]nous ne savons pas[/i] ...



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

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=71E507EAA235C9C885256C5A00548B8C|View this thread on the  forum...]]