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, 20) ','
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
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
On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com 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
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
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
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
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:
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
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
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
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
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:
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,
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
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
16 matches
Mail list logo