#1  
Old 17th October 2003, 09:35 PM
Holger Franke
 
Posts: n/a
Default 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



  #2  
Old 18th October 2003, 04:36 AM
Rodrigo Gómez [NDX]
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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  
Old 20th October 2003, 08:02 PM
Holger Franke
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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  
Old 20th October 2003, 10:16 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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  
Old 21st October 2003, 01:08 AM
Holger Franke
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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  
Old 21st October 2003, 01:33 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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  
Old 21st October 2003, 03:20 AM
Holger Franke
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

When 1.02 is coming?

Holger


  #8  
Old 21st October 2003, 05:02 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Completed will not be true after call ReIndexTable

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +11. The time now is 07:22 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.