[[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]]


==== Getting list of Indexes ... (OpenInsight Specific) ====
=== At 22 OCT 1998 01:45:35PM DSig  (SigSolutions) wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
is there a routine which will return a list of all indexes for a table or tables .. list_index of course can't be used .. it does not seem to return anything programatically ..



thanks



DSig

David Tod Sigafoos ~ SigSolutions

dsig@teleport.com
</QUOTE>
----

=== At 22 OCT 1998 02:06PM Greg James, ISIS, Inc. wrote:  ===

<QUOTE>There is some code in an old on-line discussion posting that is the equivalent of List_Index.



http://www.revelation.com/WebSite/discuss.nsf/09d90959a1a106db8525652c0042cb86/8DD9AAC4F5F81B5B8525656F00463145?OpenDocument.



Hope this is what you are looking for.



Greg

</QUOTE>

----

=== At 22 OCT 1998 02:22PM Andrew P McAuley wrote:  ===

<QUOTE>Well Dave, you could have typed this..



Compile Function ListIndexes( Void )





Tablelist	=	@Tables(0)

IndexList	=	""

Pos		=	0

Mark		=	0



Loop

Remove NextVal From TableList At Pos Setting Mark

If NextVal1,1=!" Then

IndexList	:=	NextVal2,999 : @Fm

End

While Mark

Repeat



IndexList-1,1	=	""



Return IndexList



faster than your original message.... 



amcauley@sprezzatura.com 

[url=http://www.sprezzatura.com" ]Sprezzatura Ltd[/url]

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

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









ps Thanks Carl! 

</QUOTE>

----

=== At 26 OCT 1998 10:23AM DSig  (SigSolutions) wrote:  ===

<QUOTE>Greg .. 



Thanks



DSig

</QUOTE>

----

=== At 26 OCT 1998 10:24AM DSig  SigSolutions wrote:  ===

<QUOTE>Andrew .. 



Thanks 



PS .. you to carl 

</QUOTE>


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