Hello All,
I'm facing a problem while executing more than 1 simultaneous queries thru C# code.
I'm calling 2 select stored procedures from my C# code. All the boiler-plate code is in a class having static methods. That is, opening of connetction, beginning transaction, making parameters & command objects. After query execution, I'm committing the txn, and closing the connection. The problem is that both call are asynchronous, it can extend up to more than 2 calls as well. Which ever of the call executes first, it fetches the data, the other one hangs. I don't know to handle up with this situation. The isolation level I'm setting to ReadUncommitted, just in case it requires, however both of queries fetches data from different tables.
I'm not able to figure out what else should be done, apart from committing txn. Please help me in making out this code working. All of the stored procedures are individually working fine.

Thanx in Advance,
Meghansh.

Algirdas Gurskis <algirdas.gurskis@...> wrote:
Beautiful !

It works! :)

Here is a typical declaration from the ib_udf.sql script:

DECLARE EXTERNAL FUNCTION substr
CSTRING(80), SMALLINT, SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT 'IB_UDF_substr' MODULE_NAME 'ib_udf';

COMMIT;
//

Sincerely,
Algis

Software manager
Spaineta Ltd.

http://www.ezona.lt

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


Yahoo! Groups SponsorADVERTISEMENT

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



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





---------------------------------
Yahoo! Plus - For a better Internet experience


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