Paradox Community

Items in pnews.paradox-programming

Subject:Re: Creating Secondary Index
Date:Thu, 14 Dec 2023 17:43:19 -0800
From:Peter <peterspammenot@whiteknight.email>
Newsgroups:pnews.paradox-programming
Did a bit more searching and found the answer. Need to use arrays and 
"createindex"

dyn["maintained"] = True
dyn["IndexName"] = "abc"
dyn["caseinsensitive"] = True

aryFields[1] = "TStatus"
aryFields[2] = "Cat"
aryFields[3] = "DueDate"

tbl.attach(":PRIV:the table")

if not tbl.createIndex(dyn.aryFields) then
    errorShow()
endIf

This works, thank you Jim Giner.


On 12/14/2023 05:19 p.m., Peter wrote:
> 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")


Copyright © 2004 thedbcommunity.com