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

> On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær > svein.erling.tysv...@kreftregisteret.no [firebird-support] > wrote: > > Sukhen wrote: update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query. > > I answered: >>> Could

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

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]" wrote:   >    Select first(1) u.UNIT_ID from m_unit u > where (upper(trim(u.UNIT_NAME))= up

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

>    Select first(1) u.UNIT_ID from m_unit u >where (upper(trim(u.UNIT_NAME))= upper(trim(:MAIN_UNIT)) >or upper(trim(u.UNIT_SYMBOL))=upper(trim(:MAIN_UNIT))) > and coalesce(CONVERSION_UNIT_ID,0)=0 Into :Main_Unit_Id; Does this select use any index at all? How many records are t

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

table & stored procedure structureCREATE TABLE M_ITEM(  ITEM_IDS Integer NOT NULL,  SP_ITEM_CODES Varchar(20), Its a column not stored procedure,in front end we check if any columns starts with SP_ then code to be generated using sp  ITEM_NAMES Varchar(50),  RATE Decimal(10,2),bla,bla),  CON

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

>For iLoop as Integer=0 to grid.Rows.Count-1'Grid Has 100,000 Rows >'-Sometimes Hang Here Also- >rdr = Get_Reader("USP_CHECK_AND_GET_ITEM_EXIST('" & >Mid(Trim(dicFields_Name.Item("SP_ITEM_CODES")), 1, 20) & "','" & >Mid(Trim(dicFields_Name.Item("ITEM_PART_CODES")), 1,

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

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

Sukhen wrote: >>>update never fails but it fails in insert query. loop run in a single >>>connection with a new datarows in same query. I answered: >>I think it is about time to show us some code (not all). Could it be that >>another transaction not visible to your current >>transaction has ins

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

please, somebody help me out On Monday, February 23, 2015 3:57 PM, "SUKHEN DASS sukhend...@yahoo.com [firebird-support]" wrote:   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 E

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

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]" wrote:   >update never fails but it fails in insert query. loop

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

>update never fails but it fails in insert query. loop run in a single >connection with a new datarows in same query. I think it is about time to show us some code (not all). Could it be that another transaction not visible to your current transaction has inserted a row that creates a lock conf

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

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]" wrote:   >>please, somone guide me where i am

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

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 wrote: 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

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

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 wrote: update ne

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

>>please, somone guide me where i am wrong >> >> This support list is for the Firebird database. For the .NET >> providers, you need to subscribe to the firebird-net-provider list: >> List-Subscribe: >> , >> >At first gl

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

On Mon, 23 Feb 2015 21:28:20 +1300, "Helen Borrie hele...@iinet.net.au [firebird-support]" wrote: > At 09:04 p.m. 23/02/2015, SUKHEN DASS sukhend...@yahoo.com > [firebird-support] wrote: > > >>please, somone guide me where i am wrong > > This support list is for the Firebird database. For the

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

At 09:04 p.m. 23/02/2015, SUKHEN DASS sukhend...@yahoo.com [firebird-support] wrote: >please, somone guide me where i am wrong This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list: List-Subscribe:

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

please, somone guide me where i am wrong On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS sukhend...@yahoo.com [firebird-support]" wrote:   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 ins