firebird-net-provider

[Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello firebird-net-provider,

  i have simple procedure in vb.net:

    Private Sub SaveDMDetails()
        If Not bmdtDMDetails.Current.GetType() Is GetType(DataRowView) Then
            Return
        End If
        bmdtDMDetails.EndCurrentEdit()

        If DataTableHasChanges(dtDMDetails) Then
            Try
                con.Open()
                Dim _transaction As FbTransaction = con.BeginTransaction( _
                    FbTransactionOptions.NoWait Or _
                    FbTransactionOptions.ReadCommitted Or _
                    FbTransactionOptions.RecVersion _
                    )

                dtaDMDetails.SelectCommand.Transaction = _transaction

                dtaDMDetails.Update(dtDMDetails)

                _transaction.Commit()
                con.Close()
            Catch ex As Exception
                MessageBox.Show(ex.Message)
            End Try

            ' Возможно стоит обновить что-то на форме...
            Dim drvDMDetails As DataRowView = bmdtDMDetails.Current
            Dim drvList As DataRowView = bmdvDivsMembership.Current
            drvList("EMPLOYE") = drvDMDetails("EMPLOYE")
            drvList("SUBDIV") = drvDMDetails("SUBDIV")
            drvList("STAFFBYWORK") = drvDMDetails("STAFFBYWORK")
            drvList("RANK") = drvDMDetails("RANK")
        End If
    End Sub

    and it's work fine... but on 3th edition & save of record i'm got
    exception NullReferenceException in this call:
                dtaDMDetails.Update(dtDMDetails)

    Can't understand what's this... :( Can't find bug :((
    And this not fb-provider bug :) or i can't create test case :(

-- 
Best regards,
 Dmitry                          mailto:fd...@ua...

Re: [Firebird-net-provider] simple procedure in vb.net

[<car...@te...>]

Hello:

>     Can't understand what's this... :( Can't find bug :((
>     And this not fb-provider bug :) or i can't create test case :(

Can you make a ex.ToString() and send the result ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Friday, April 9, 2004, 2:50:25 PM, you wrote:

>>     Can't understand what's this... :( Can't find bug :((
>>     And this not fb-provider bug :) or i can't create test case :(
CGÁ> Can you make a ex.ToString() and send the result ??
    sorry :) i want do it, but forget this...

   ex.ToString() =
   System.NullReferenceException: Object reference not set to an
   instance of an object. 
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
   DataTableMapping tableMapping) 
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at DSUET.Personnel.DivsMembershipForm.SaveDMDetails() in
   S:\ISUNZ2\src\DSUET.Personnel\Ïðàö³âíèêè\DivsMembershipForm.vb:line 1212

   i'm try all :((( a don't know what...

   PS: .NET Framework 1.0 - now it's principial
   
-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] simple procedure in vb.net

[<car...@te...>]

Hello:

>    ex.ToString() =
>    System.NullReferenceException: Object reference not set to an
>    instance of an object. 
>    at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
>    DataTableMapping tableMapping) 
>    at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
>    at DSUET.Personnel.DivsMembershipForm.SaveDMDetails() in
>    S:\ISUNZ2\src\DSUET.Personnel\Ïðàö³âíèêè\DivsMembershipForm.vb:line 1212

It's giving in the DbDataAdapter class :P it's going to be a little 
difficult to know the problem.

You can't do a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Friday, April 9, 2004, 3:28:49 PM, you wrote:

CGÁ> It's giving in the DbDataAdapter class :P it's going to be a little
CGÁ> difficult to know the problem.
     I know... :)

CGÁ> You can't do a test case ??
     I tried to do test case but me as well as not to manage to repeat
     the mistake. In currently test case all beautifully work :(

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re[3]: [Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello Dmitry,

Friday, April 9, 2004, 3:53:16 PM, you wrote:

CGÁ>> You can't do a test case ??
DA>      I tried to do test case but me as well as not to manage to repeat
DA>      the mistake. In currently test case all beautifully work :(
    I recompile now it for .NET Framework 1.1 -- some new bugs %)
    But my problem -- anyway exists -- i'm don't understand where bug
    :( i have now 2 forms with same error behavior. strange...
    3th update -- always with exception :(

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...

Re: [Firebird-net-provider] simple procedure in vb.net

[<car...@te...>]

Hello:

>     I recompile now it for .NET Framework 1.1 -- some new bugs %)
>     But my problem -- anyway exists -- i'm don't understand where bug
>     :( i have now 2 forms with same error behavior. strange...
>     3th update -- always with exception :(

I'm sorry but i need a test case :( (are you testing it with 1.6 ??)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re[2]: [Firebird-net-provider] simple procedure in vb.net

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Friday, April 9, 2004, 4:46:07 PM, you wrote:

>>     I recompile now it for .NET Framework 1.1 -- some new bugs %)
>>     But my problem -- anyway exists -- i'm don't understand where bug
>>     :( i have now 2 forms with same error behavior. strange...
>>     3th update -- always with exception :(
CGÁ> I'm sorry but i need a test case :( (are you testing it with 1.6 ??)
    yes i'm test it with todays cvs sources of 1.6. (with previous version
    of 1.6 don't work too), and on 1.5 i'm don't test...

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...