Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Following Code/Process I am Using Private Function Process_Grid_Data() As BooleanDim rdr As FbDataReaderDim dicStoredProc As New Dictionary(Of String, String)Dim fbTrans As FbTransaction = NothingDim strErrorMsg as String=Dim Is_Update as Boolean=FalseDim nITEM_IDS As Long = 0Dim nGroup_IDS As

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
unit_id is primary key and this table(m_unit ) has hardly 20 records On Tuesday, February 24, 2015 3:43 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote:       Select first(1) u.UNIT_ID from m_unit u where

Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message - Od: SUKHEN DASS sukhend...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com firebird-support@yahoogroups.com Temat: [firebird-support] Re

Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
insert statement parameters to tabbed csv and you will see at what statment it stop. If this is always at the same statement, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message - Od: SUKHEN DASS sukhend...@yahoo.com [firebird-support

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird On Monday, February 23, 2015 3:51 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote:   update never fails but

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
please, somone guide me where i am wrong On Monday, February 23, 2015 11:11 AM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote:   Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
have checked with wait and no wait both dint work could you please, how to set wait/no wait in back end i.e. in firebird database .I have set in front end for TransactionBehavior class wait/no wait both dint work  On Monday, February 23, 2015 3:22 PM, SUKHEN DASS sukhend...@yahoo.com

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
it just hang without any error..could you please, suggest how can i catch the error if any from backend On Monday, February 23, 2015 3:24 PM, SUKHEN DASS sukhend...@yahoo.com wrote: have checked with wait and no wait both dint work could you please, how to set wait/no wait in back

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query. On Monday, February 23, 2015 2:51 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote:  

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
please, somebody help me out On Monday, February 23, 2015 3:57 PM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote:   is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird On Monday

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-22 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.But inside the loop while executing ExecuteNonQuery control does not come back

[firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-22 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.But inside the loop while executing ExecuteNonQuery control does not come back