Subject Re: [IBO] Re:BackGround Query
Author Vincenzo Scarpellino
Post date 2004-07-26T15:06:05Z
Ok it is similar to my code, but only Protocol is differrent, my is cpLocal. If I set Protocol to cpLocal It no work fine so as waiting, instead with cpTCP_IP work fine. I have a button on my form to execute a background query in an other separate Form then if I click more time while a previouse query working last query is ok but first is suspend ?

From: Robert martin
To: IBObjects@yahoogroups.com
Sent: Wednesday, July 21, 2004 9:26 PM
Subject: Re: [IBO] Re:BackGround Query


No problem. Note that I am using IBO components (there is no IBO session component however).


procedure TProcessing.Execute;
begin
if (ClientSesion = Nil) then begin
ClientSesion := TIB_Session.Create(Nil);
ClientSesion.UseCursor := False;

IBODataBase := TIBODatabase.Create(ClientSesion);
IBODataBase.Path := Owner.DataBasefullPath;
IBODataBase.Password := WS_DB_PASSWORD;
IBODataBase.Username := WS_DB_USERNAME;
IBODataBase.Protocol := cpTCP_IP;
IBODataBase.PageSize := WS_DB_PAGESIZE;
IBODataBase.IB_Session := ClientSesion;
IBODataBase.SQLDialect := 3;
IBODataBase.Connected := True;


IncrementTable := TIBOTable.Create(ClientSesion); //Used to get unique IDs
IncrementTable.IB_Connection := IBODataBase;
IncrementTable.TableName := 'Increment';
IncrementTable.OpenIfClosed;

UpdateQuery := TIBOQuery.Create(ClientSession);
UpdateQuery.IB_Connection := IBODataBase;
end;

while (Terminated = False) do begin
.....
end;

UpdateQuery.Free;

IncrementTable.Close;
IncrementTable.Free;

IBODataBase.Connected := False;
IBODataBase.Free;

ClientSesion.Free;
end;



Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
----- Original Message -----
From: Vincenzo Scarpellino
To: IBObjects@yahoogroups.com
Sent: Wednesday, July 21, 2004 8:27 PM
Subject: Re: [IBO] Re:BackGround Query


>Create a Session for each thread, .Create(Nil)
>then create a connection .create(Session) also assign the >Ib_Session property. Do the same for all your Table an >Query objects.

Session is TIB_Session ? Can you post a little sample ?


----- Original Message -----
From: Robert martin
To: IBObjects@yahoogroups.com
Sent: Tuesday, July 20, 2004 10:07 PM
Subject: Re: [IBO] Re:BackGround Query


Are you setting the connection path using the path parameter or the DatabaseName parameter? I had a similar problem when using databasename, changing it to path helped.

Create a Session for each thread, .Create(Nil)
then create a connection .create(Session) also assign the Ib_Session property. Do the same for all your Table an Query objects.

Create your session & connection in the execute part of the thread. Free it at the end of the execute.

This structure fixed all my problems. Hope this is clear enough :)


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
----- Original Message -----
From: Vincenzo Scarpellino
To: IBObjects@yahoogroups.com
Sent: Wednesday, July 21, 2004 4:15 AM
Subject: Re: [IBO] Re:BackGround Query


I am converting a demo project of borland (see borland\Delphi7\demos\db\bkQuery) I
converted TQuery with IBOQuery, TDatabase with IB_Connection, IB_Transaction,
TSession with IB_Session).

Server = FB 1.5.1, Connection = Local

My problem is when I click quickly on button execute it suspend and I must reset, all is ok if I wait previous query has terminated.

It is only a simple query to Database.

I tried demo thread project in IBO4\Samples\Threads and It has the same problem. Why ? Is there a sample of Threads works fine.

Thank You


----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Tuesday, July 20, 2004 1:23 PM
Subject: Re: [IBO] Re:BackGround Query


Vincenzo,

At 02:10 PM 20/07/2004 +0100, you wrote:
>I am using D7, IBO 4.3.Aa, FB 1.5.1. If I execute thread when previous
>thread isn't terminated my application is suspended and I am forced to
>reset it from Delphi.

Please describe
a) how your application is connecting to the database (Server, Path, protocol)
b) what is being done inside the threads

Helen



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Rinfresca la tua estate con i climatizzatori ed i ventilatori
* che trovi disponibili. Crios, Orieme, Hokkaido, Argo, Carrier, Vortice
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid&50&d -7

[Non-text portions of this message have been removed]



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Corri da Oliviero! Sandali, infraditi, calzature moda-sport per lui e per lei delle migliori marche!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid&63&d!-7://adv.email.it/cgi-bin/foclick.cgi?mid&11&d!-7

[Non-text portions of this message have been removed]



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Preparati alla prova costume con il nuovo sistema di America Diet System รจ facile e naturale!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid&30&d&-7mid&24&d&-7

[Non-text portions of this message have been removed]