> We don't use tables at all - only queries and stored procedures. The
> queries and

and where do you store your data then? What do the queries query? ;-)

Btw, Is your app multithreaded or do you use the timer components?

Raf

P.S I am pushing into this direction because you indicated that this issue
occurs on XP and Win98 (regardles of memory config) so from my point of view
it's unlikely that it's an OS issue.


Tim Ledgerwood wrote:

>>I have run into this many times with IB6 and IBExpert. If I open a table for
>>edit in IBExpert and dont commit the transaction and my application tries to
>>read that record, my app will just sit there and wait until I commit or
>>rollback
>>the edit.
>>
>>I can't remember if I could duplicate this issue with IBConsol.
>>
>>Btw, can you duplicate the behavior by running a script in IBConsole that
>>mimics
>>your application behavior?
>>
>>Raf
>
>
> Hi Raf,
>
> We don't use tables at all - only queries and stored procedures. The
> queries and
> stored procedures all happen within a transaction context, and the data set
> is closed
> and the transaction committed as soon as the client application is finished
> with it.
>
> In many cases, the code looks something like this :
>
> function getvalue(recordid : integer) : string;
> var
> ReturnValue : String;
> begin
> ReturnValue := 'NONE';
> try
> try
> with adataset do
> begin
> if active then close;
> if not transaction.intransaction then
> transaction.starttransaction;
> //fill the input parameters and open the dataset
> end;
> ReturnValue := adataset.fieldbyname('value').AsString;
> except
> begin
> //exception handling code here
> end;
> end;
> finally
> begin
> adataset.transaction.commit;
> adataset.close;
> end;
> end;
> result := ReturnValue;
> end;
>
> There is also exception handling code within the procedure. The point is
> that the database
> transactions are as atomic as I can possibly make them - they never last
> longer than they
> absolutely have to.
>
> The other point is that if it were a problem with transactions, I would
> expect that the
> problem ALWAYS happens. Instead, the problem is intermittent, which is one
> of the reasons
> that it is difficult to identify.
>
> Regards
>
> Tim
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>

--
Rafael Szuminski
Email:raf@...
Phone:(949)939 - 2458
www.BDCSoftware.com