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

2015-02-23 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

2015-02-23 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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] Re: Is there still a difference between sweep and gabage collection?

2015-02-23 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Many thanks for your comments! Thomas -- Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604 Mail thomas.beckm...@assfinet.de ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 5

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

2015-02-23 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>>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

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

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

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

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

2015-02-23 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>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

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

Re: [firebird-support] Multiple WHERE clauses

2015-02-23 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

[firebird-support] fdb named parameters

2015-02-23 Thread Ernesto Benestante ebenesta...@gmx.net [firebird-support]
Hi, does FDB support named parameters in queries? Other python database adapters support specifying a name for the parameters in the SQL string and passing a dict to execute(), to bind the parameters to its values. Something like this: cur.execute('select * from customers where id = %(cid)d', {

Re: [firebird-support] fdb named parameters

2015-02-23 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 10:04 a.m. 24/02/2015, Ernesto Benestante ebenesta...@gmx.net [firebird-support] wrote: >Hi, does FDB support named parameters in queries? Other python database >adapters support specifying a name for the parameters in the SQL string >and passing a dict to execute(), to bind the parameters to

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

2015-02-23 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
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