I am having a "not all variables bound" issue when trying to delete a row
from a datagrid.

I have a datagrid populated with data from a oracle table as follows:

da = New OracleDataAdapter("SELECT a.inst, a.group, a.privs,
b.field FROM table a, table b WHERE.......

da.Fill(ds, "TW_GROUP_PRIVS")
da.datamember = "TW_GROUP_PRIVS")


I have the insert and update statements working correctly, they are as
follows:

Dim cmd As New OracleCommand("UPDATE TW_GROUP_PRIVS SET group =
riginal_group, inst = :Original_inst, privs = rivs WHERE inst =
riginal_inst AND group = riginal_group")

cmd.Parameters.Add(New OracleParameter("riginal_group",
OracleType.VarChar, 30, "GROUP"))
cmd.Parameters.Add(New OracleParameter("riginal_inst",
OracleType.VarChar, 10, "Inst"))
cmd.Parameters.Add(New OracleParameter(":PRIVS",
OracleType.VarChar, 37, "PRIVS"))
cmd.Parameters.Add(New OracleParameter(":ORIGINAL_DESCRIPTION",
OracleType.VarChar, 100, "DESCRIPTION"))


Dim cmd2 As New OracleCommand("INSERT INTO TW_GROUP_PRIVS
(group, inst, privs, description)
VALUES (:group_name, :institution_id, rivs, :field)")

cmd2.Parameters.Add(New OracleParameter(":group",
OracleType.VarChar, 30, "GROUP"))
cmd2.Parameters.Add(New OracleParameter(":inst",
OracleType.VarChar, 10, "Inst"))
cmd2.Parameters.Add(New OracleParameter(":PRIVS",
OracleType.VarChar, 37, "PRIVS"))
cmd2.Parameters.Add(New OracleParameter(":field",
OracleType.VarChar, 100, "field"))

cmd.Connection = Conn
cmd2.Connection = Conn
da.UpdateCommand = cmd
da.InsertCommand = cmd2
Conn.Open()
da.Update(ds, "TW_GROUP_PRIVS")

I am running into issues with the delete portion of the code.

First, I remove the row from the datagrid:
if (Me.BindingContext(ds, "TW_GROUP_PRIVS").Count > 0) Then
Me.BindingContext(ds,
"TW_GROUP_PRIVS").RemoveAt(Me.BindingContext(ds, "TW_GROUP_PRIVS").Position)
end if

Now I want to delete the row from the source table:

'Dim cmd3 As New OracleCommand("DELETE FROM TW_GROUP_PRIVS WHERE
inst = riginal_inst" _
&" AND group = riginal_group AND privs = riginal_privs and
description = riginal_field")

cmd3.Parameters.Add(New OracleParameter(":Original_group",
OracleType.VarChar, 30, "GROUP"))
cmd3.Parameters.Add(New OracleParameter(":Original_inst",
OracleType.VarChar, 10, "Inst"))
cmd3.Parameters.Add(New OracleParameter(":Original_PRIVS",
OracleType.VarChar, 37, "PRIVS"))
cmd3.Parameters.Add(New OracleParameter(":Original_field",
OracleType.VarChar, 100, "field"))

cmd3.Connection = Conn
da.DeleteCommand = cmd3
Conn.Open()
da.Update(ds, "TW_GROUP_PRIVS") <---- ERROR LINE

Getting the error on the final line here. The error being "ORA-010008: Not
all variable bound"

Any ideas on why this is failing?

Thanks in advance.
--
Kevin

--
Kevin

Ksedran,

The answer is simple.

The removeat, removes a datarow completly from a dataset.
http://msdn.microsoft.com/library/de...oveattopic.asp

The delete set the rowstate from a datarow to deleted.
http://msdn.microsoft.com/library/de...eletetopic.asp


In the first situation there is nothing to delete in the database.

(You are not the first one)

I hope this helps

Cor


"ksedran" <(E-Mail Removed)>

>I am having a "not all variables bound" issue when trying to delete a row
> from a datagrid.
>
> I have a datagrid populated with data from a oracle table as follows:
>
> da = New OracleDataAdapter("SELECT a.inst, a.group, a.privs,
> b.field FROM table a, table b WHERE.......
>
> da.Fill(ds, "TW_GROUP_PRIVS")
> da.datamember = "TW_GROUP_PRIVS")
>
>
> I have the insert and update statements working correctly, they are as
> follows:
>
> Dim cmd As New OracleCommand("UPDATE TW_GROUP_PRIVS SET group =
> riginal_group, inst = :Original_inst, privs = rivs WHERE inst =
> riginal_inst AND group = riginal_group")
>
> cmd.Parameters.Add(New OracleParameter("riginal_group",
> OracleType.VarChar, 30, "GROUP"))
> cmd.Parameters.Add(New OracleParameter("riginal_inst",
> OracleType.VarChar, 10, "Inst"))
> cmd.Parameters.Add(New OracleParameter(":PRIVS",
> OracleType.VarChar, 37, "PRIVS"))
> cmd.Parameters.Add(New OracleParameter(":ORIGINAL_DESCRIPTION",
> OracleType.VarChar, 100, "DESCRIPTION"))
>
>
> Dim cmd2 As New OracleCommand("INSERT INTO TW_GROUP_PRIVS
> (group, inst, privs, description)
> VALUES (:group_name, :institution_id, rivs, :field)")
>
> cmd2.Parameters.Add(New OracleParameter(":group",
> OracleType.VarChar, 30, "GROUP"))
> cmd2.Parameters.Add(New OracleParameter(":inst",
> OracleType.VarChar, 10, "Inst"))
> cmd2.Parameters.Add(New OracleParameter(":PRIVS",
> OracleType.VarChar, 37, "PRIVS"))
> cmd2.Parameters.Add(New OracleParameter(":field",
> OracleType.VarChar, 100, "field"))
>
> cmd.Connection = Conn
> cmd2.Connection = Conn
> da.UpdateCommand = cmd
> da.InsertCommand = cmd2
> Conn.Open()
> da.Update(ds, "TW_GROUP_PRIVS")
>
> I am running into issues with the delete portion of the code.
>
> First, I remove the row from the datagrid:
> if (Me.BindingContext(ds, "TW_GROUP_PRIVS").Count > 0) Then
> Me.BindingContext(ds,
> "TW_GROUP_PRIVS").RemoveAt(Me.BindingContext(ds,
> "TW_GROUP_PRIVS").Position)
> end if
>
> Now I want to delete the row from the source table:
>
> 'Dim cmd3 As New OracleCommand("DELETE FROM TW_GROUP_PRIVS
> WHERE
> inst = riginal_inst" _
> &" AND group = riginal_group AND privs = riginal_privs and
> description = riginal_field")
>
> cmd3.Parameters.Add(New OracleParameter(":Original_group",
> OracleType.VarChar, 30, "GROUP"))
> cmd3.Parameters.Add(New OracleParameter(":Original_inst",
> OracleType.VarChar, 10, "Inst"))
> cmd3.Parameters.Add(New OracleParameter(":Original_PRIVS",
> OracleType.VarChar, 37, "PRIVS"))
> cmd3.Parameters.Add(New OracleParameter(":Original_field",
> OracleType.VarChar, 100, "field"))
>
> cmd3.Connection = Conn
> da.DeleteCommand = cmd3
> Conn.Open()
> da.Update(ds, "TW_GROUP_PRIVS") <---- ERROR LINE
>
> Getting the error on the final line here. The error being "ORA-010008: Not
> all variable bound"
>
> Any ideas on why this is failing?
>
> Thanks in advance.
> --
> Kevin
>
> --
> Kevin

Thanks Cor!!

That got me on the right track!


"Cor Ligthert" wrote:

> Ksedran,
>
> The answer is simple.
>
> The removeat, removes a datarow completly from a dataset.
> http://msdn.microsoft.com/library/de...oveattopic.asp
>
> The delete set the rowstate from a datarow to deleted.
> http://msdn.microsoft.com/library/de...eletetopic.asp
>
>
> In the first situation there is nothing to delete in the database.
>
> (You are not the first one)
>
> I hope this helps
>
> Cor
>
>
> "ksedran" <(E-Mail Removed)>
>
> >I am having a "not all variables bound" issue when trying to delete a row
> > from a datagrid.
> >
> > I have a datagrid populated with data from a oracle table as follows:
> >
> > da = New OracleDataAdapter("SELECT a.inst, a.group, a.privs,
> > b.field FROM table a, table b WHERE.......
> >
> > da.Fill(ds, "TW_GROUP_PRIVS")
> > da.datamember = "TW_GROUP_PRIVS")
> >
> >
> > I have the insert and update statements working correctly, they are as
> > follows:
> >
> > Dim cmd As New OracleCommand("UPDATE TW_GROUP_PRIVS SET group =
> > riginal_group, inst = :Original_inst, privs = rivs WHERE inst =
> > riginal_inst AND group = riginal_group")
> >
> > cmd.Parameters.Add(New OracleParameter("riginal_group",
> > OracleType.VarChar, 30, "GROUP"))
> > cmd.Parameters.Add(New OracleParameter("riginal_inst",
> > OracleType.VarChar, 10, "Inst"))
> > cmd.Parameters.Add(New OracleParameter(":PRIVS",
> > OracleType.VarChar, 37, "PRIVS"))
> > cmd.Parameters.Add(New OracleParameter(":ORIGINAL_DESCRIPTION",
> > OracleType.VarChar, 100, "DESCRIPTION"))
> >
> >
> > Dim cmd2 As New OracleCommand("INSERT INTO TW_GROUP_PRIVS
> > (group, inst, privs, description)
> > VALUES (:group_name, :institution_id, rivs, :field)")
> >
> > cmd2.Parameters.Add(New OracleParameter(":group",
> > OracleType.VarChar, 30, "GROUP"))
> > cmd2.Parameters.Add(New OracleParameter(":inst",
> > OracleType.VarChar, 10, "Inst"))
> > cmd2.Parameters.Add(New OracleParameter(":PRIVS",
> > OracleType.VarChar, 37, "PRIVS"))
> > cmd2.Parameters.Add(New OracleParameter(":field",
> > OracleType.VarChar, 100, "field"))
> >
> > cmd.Connection = Conn
> > cmd2.Connection = Conn
> > da.UpdateCommand = cmd
> > da.InsertCommand = cmd2
> > Conn.Open()
> > da.Update(ds, "TW_GROUP_PRIVS")
> >
> > I am running into issues with the delete portion of the code.
> >
> > First, I remove the row from the datagrid:
> > if (Me.BindingContext(ds, "TW_GROUP_PRIVS").Count > 0) Then
> > Me.BindingContext(ds,
> > "TW_GROUP_PRIVS").RemoveAt(Me.BindingContext(ds,
> > "TW_GROUP_PRIVS").Position)
> > end if
> >
> > Now I want to delete the row from the source table:
> >
> > 'Dim cmd3 As New OracleCommand("DELETE FROM TW_GROUP_PRIVS
> > WHERE
> > inst = riginal_inst" _
> > &" AND group = riginal_group AND privs = riginal_privs and
> > description = riginal_field")
> >
> > cmd3.Parameters.Add(New OracleParameter(":Original_group",
> > OracleType.VarChar, 30, "GROUP"))
> > cmd3.Parameters.Add(New OracleParameter(":Original_inst",
> > OracleType.VarChar, 10, "Inst"))
> > cmd3.Parameters.Add(New OracleParameter(":Original_PRIVS",
> > OracleType.VarChar, 37, "PRIVS"))
> > cmd3.Parameters.Add(New OracleParameter(":Original_field",
> > OracleType.VarChar, 100, "field"))
> >
> > cmd3.Connection = Conn
> > da.DeleteCommand = cmd3
> > Conn.Open()
> > da.Update(ds, "TW_GROUP_PRIVS") <---- ERROR LINE
> >
> > Getting the error on the final line here. The error being "ORA-010008: Not
> > all variable bound"
> >
> > Any ideas on why this is failing?
> >
> > Thanks in advance.
> > --
> > Kevin
> >
> > --
> > Kevin
>
>
>