rs.Properties("Unique Table")

[MichaelLotosh]

Hello,

VBUC didn't convert the code: rs.Properties("Unique Table") = "table_name"

Do you have any recommendations how to handle it?

Thanks,

Michael

[OlmanQuesada]

Hi Michael,

 

Could be that possible to give us more context about the code. Perhaps a small VB6 sample code.

 

Regards

 

Olman Q

[MichaelLotosh]

Hi Olman,

We populate the recordset with a join of table1 and table2. In some other place in code we need to delete the record from table1. In order to do it we use rs.delete. Without rs.Properties("Unique Table") = "table1" the recordset will delete the records from both tables and not just table1.

Please let me know if it's still not clear.

Thanks,

Michael

[OlmanQuesada]

Hi Michael,

ADO.Net does not provide a direct way to achieve that, so the migrated code should be modified to get a similar result.
As the ADORecordsetHelper inherits from a Dataset, the properties of that class could be used:

Given rs is a ADORecordsetHelper you can try the following:
DataRow rowDel=ds.Tables["table1"].Rows[<IndexOfTheRowToDelete>];
rs.Tables["table1"].Rows.Remove(rowDel);
rs.Delete()
 

Cheers,

OlmanQ

[KevinKor]

How would one modify the code to get similar results for an Update method?

Currently, the method goes as follows:

 

"AdoRecordSetHelper.getProperties().Item("Unique Table").setValue("table");"

 

Thanks

[OlmanQuesada]

You should recreate a new update from scratch that reflects the changes in that table. Please take a look at this URL
https://stackoverflow.com/questions/34623292/how-to-update-a-table-using-join-in-visual-studio