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

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

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] 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 mailto:thomas.beckm...@assfinet.de ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 •

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] firebird-support@yahoogroups.com 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

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: https://lists.sourceforge.net/lists/listinfo/firebird-net-provider, At first glance it sounds

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] 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 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 inserted a row