VB.NET 2005 (Database Deletion issues)

[PlanTec]

Hi all,

I am new to these forums and I am having some trouble with trying to delete records from an oracle table using the below syntax/object

DataSetXX.TableYYY.Rows(n).Delete()

What is happening is the command is completing sucessfully yet the records are not being deleted. Is there something else I need to add to convert these tagged records for deletion into actual deletion?

I am using the Oracle native driver, I have also tried the OLE driver as well.

Any help is appreciated.

Regards,

Kent Lawrence.

[techguru]

Hi all,

I am new to these forums and I am having some trouble with trying to delete records from an oracle table using the below syntax/object

DataSetXX.TableYYY.Rows(n).Delete()

What is happening is the command is completing sucessfully yet the records are not being deleted. Is there something else I need to add to convert these tagged records for deletion into actual deletion?

I am using the Oracle native driver, I have also tried the OLE driver as well.

Any help is appreciated.

Regards,

Kent Lawrence.

Hello Kent,

it's kind of tricky when it comes to oracle database... can you send me the source code or paste the code ...

Thanks,
John

[techvinny]

Looks like you are missing to call the AcceptChanges method on the datatable after deleting the row

DataSetXX.Tables[0].Rows(n).Delete();
DataSetXX.Table[0].AcceptChanges();

AcceptChanges is used to commit all the changes made to the datatable since the last time AcceptChanges was called.

Hi all,

I am new to these forums and I am having some trouble with trying to delete records from an oracle table using the below syntax/object

DataSetXX.TableYYY.Rows(n).Delete()

What is happening is the command is completing sucessfully yet the records are not being deleted. Is there something else I need to add to convert these tagged records for deletion into actual deletion?

I am using the Oracle native driver, I have also tried the OLE driver as well.

Any help is appreciated.

Regards,

Kent Lawrence.