Completed will not be true after call ReIndexTable

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

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
>
>
>

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

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

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;
}
//--------------------------------------------------------------------------
-

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;
> }
>
//--------------------------------------------------------------------------
> -
>
>
>

When 1.02 is coming?

Holger

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
>
>