|
Log in |
FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() I want to reindex my indizes (BCB5, nx1.01).
I use a table WT and call: TnxAbstractTaskInfo = NULL; WT->ReIndexTable("IdxName", TaskInfo); Then I wait until the index is rebuilded, because I want to do the same to the next index: TnxTaskStatus Status; bool Completed; TaskInfo->GetStatus(Completed, Status); while (!Completed) { Sleep (250); Application->ProcessMessages(); TaskInfo->GetStatus(Completed, Status); } But Completed will never be true although the value of Status.tsFinished is true?! Holger |
#2
|
|||
|
|||
![]() Hi Holger!
The code certanly looks fine, compared to the code in fmTreeBrowser.pas, and old FF2 code. Could you please post a simple test project to check this? I'll try to run this without runtime packages (you could do this too) and debug the Nexus pas sources, to see what is going. The headers, at least as far as I can see, looks good. -- Rodrigo Gómez [NDX] rgomez@msa.sinspam.com.mx (remove "sinspam." from the address) "Holger Franke" <holger@ktms.de> escribió en el mensaje news:3f8fb690@wic040d.... > I want to reindex my indizes (BCB5, nx1.01). > > I use a table WT and call: > > TnxAbstractTaskInfo = NULL; > WT->ReIndexTable("IdxName", TaskInfo); > > Then I wait until the index is rebuilded, because I want to do the same to > the next index: > > TnxTaskStatus Status; > bool Completed; > TaskInfo->GetStatus(Completed, Status); > while (!Completed) { > Sleep (250); > Application->ProcessMessages(); > TaskInfo->GetStatus(Completed, Status); > } > > But Completed will never be true although the value of Status.tsFinished is > true?! > > Holger > > > |
#3
|
|||
|
|||
![]() Hello Rogrigo,
maybe it's not only a BCB-problem, because I have similar problems with SQL. I posted a question to nexusdb.public.support.sql on thursday. Per and Eivind will correct this bug with Issue #486. I think we should wait for this patch. Holger |
#4
|
|||
|
|||
![]() maybe it's not only a BCB-problem, because I have similar problems
> with SQL. I posted a question to nexusdb.public.support.sql on > thursday. Per and Eivind will correct this bug with Issue #486. I don't think your issue and the SQL issue are related. If you have a testproject for Rodrigo, that would be appreciated. -- Eivind Bakkestuen [NDD] Please, no email unless requested. Search Borland and third-party newsgroups here: www.tamaracka.com |
#5
|
|||
|
|||
![]() Ok, here my function for creating a new index.
WQ is a TnxQuery and WT is a TnxTable both connected to Session, Sever... //-------------------------------------------------------------------------- - bool __fastcall TSDM::CreateNewIndex (String nxAlias, String Table, String Field) { //Create Index WQ->AliasName = nxAlias; WQ->SQL->Text = "CREATE INDEX I" + Field + " ON \"" + Table + "\" (" + Field + ")"; WQ->ExecSQL(); //Rebindex WT->TableName = Table; WT->AliasName = nxAlias; TnxAbstractTaskInfo *TaskInfo = NULL; WT->ReIndexTable("I"+Field, TaskInfo); if (!TaskInfo) return false; TnxTaskStatus Status; bool Completed; TaskInfo->GetStatus(Completed, Status); while (!Completed) { //Completed will never be true //try here: while (!Status.tsFinished) { Application->ProcessMessages(); Sleep(250); TaskInfo->GetStatus(Completed, Status); } delete TaskInfo; return true; } //-------------------------------------------------------------------------- - |
#6
|
|||
|
|||
![]() Ok, so you DO use the non-working SQL. It should be no surprise that it
doesnt work then... fix coming in 1.02. -- Eivind Bakkestuen [NDD] Please, no email unless requested. Search Borland and third-party newsgroups here: www.tamaracka.com "Holger Franke" <holger@ktms.de> wrote in message news:3f93dcf7@wic040d.... > Ok, here my function for creating a new index. > WQ is a TnxQuery and > WT is a TnxTable > both connected to Session, Sever... > > //-------------------------------------------------------------------------- > - > bool __fastcall TSDM::CreateNewIndex (String nxAlias, String Table, String > Field) { > > //Create Index > WQ->AliasName = nxAlias; > WQ->SQL->Text = "CREATE INDEX I" + Field + " ON \"" + Table + "\" (" + > Field + ")"; > WQ->ExecSQL(); > > //Rebindex > WT->TableName = Table; > WT->AliasName = nxAlias; > TnxAbstractTaskInfo *TaskInfo = NULL; > WT->ReIndexTable("I"+Field, TaskInfo); > if (!TaskInfo) return false; > TnxTaskStatus Status; > bool Completed; > TaskInfo->GetStatus(Completed, Status); > while (!Completed) { //Completed will never be true > //try here: while (!Status.tsFinished) { > Application->ProcessMessages(); > Sleep(250); > TaskInfo->GetStatus(Completed, Status); > } > delete TaskInfo; > return true; > } > //-------------------------------------------------------------------------- > - > > > |
#7
|
|||
|
|||
![]() When 1.02 is coming?
Holger |
#8
|
|||
|
|||
![]() We have no specific date yet. Basically its "When enough fixes have
accumulated". -- Eivind Bakkestuen [NDD] Please, no email unless requested. Search Borland and third-party newsgroups here: www.tamaracka.com "Holger Franke" <holger@ktms.de> wrote in message news:3f93fbfc@wic040d.... > When 1.02 is coming? > > Holger > > |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
OT - True Story! - Phone Call to Local Council 22Apr2003 at 9am | Darren Stephens | nexusdb.public.discussions | 3 | 14th October 2011 10:21 AM |
Completed installing NexusDB into D2007 | Malcolm Cheyne | nexusdb.public.discussions | 3 | 24th May 2007 06:52 AM |
Setting the nxDatabase and other comps true->fals->true after connection loss ? | Vojko Cendak | nexusdb.public.support | 2 | 18th February 2004 07:30 PM |
Completed will not be true after call ReIndexTable | Holger Franke | Support Newsgroups | 7 | 21st October 2003 05:02 AM |
Completed-Status after call ReIndexTable | Holger Franke | nexusdb.public.support | 3 | 17th October 2003 10:10 PM |