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

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 wa

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

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

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

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

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

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

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

>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

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

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

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

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

>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

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

>    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

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

> 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