Subject: | Re: Creating Secondary Index
| Date: | Thu, 14 Dec 2023 17:19:21 -0800
| From: | Peter <peterspammenot@whiteknight.email>
| Newsgroups: | pnews.paradox-programming
|
Back on this project
They are the field names in the table
On 05/06/2018 05:09 a.m., Steven Green wrote:
>> 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")
|