Paradox Community

Items in pnews.paradox-programming

Subject:Re: Creating Secondary Index
Date:Sun, 6 May 2018 08:09:22 -0400
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-programming
> strFields = "\"Assignee\",\"TStatus\",\"DueDate\",\"Cat\""

are these examples the field names or the vars? you have the syntax kinda 
half-and-half


--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Peter"  wrote in message news:5aec8dd5$1@pnews.thedbcommunity.com...

Lots of posts on this topic but I did not find anything that addressed
this question.

The following code does not work if using a string variable (strfields,
strname)in the indexing block. It does work if the string itself is
used. Shouldn't it accept a string variable? Thank you for any comments.

strFields = "\"Assignee\",\"TStatus\",\"DueDate\",\"Cat\""
strname = "AssStaDue"

tbl.attach(strTbl)
;create secondary index
if tbl.lock("FULL") then
    Index tbl
      maintained on strfields
      to strname
    endIndex
else
    msgInfo("TABLE LOCK","Cannot lock the table to restructure")
    errorShow()
endIf

tbl.unlock("FULL") 


Copyright © 2004 thedbcommunity.com