Getting list of Indexes ... (OpenInsight 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 22 OCT 1998 01:45:35PM DSig (SigSolutions) wrote:

OpenInsight Specific

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

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

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

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

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

Sprezzatura Ltd

World Leaders in all things RevSoft

ps Thanks Carl!

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

Greg ..

Thanks

DSig

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

Andrew ..

Thanks

PS .. you to carl

View this thread on the forum...