help will be much appreciated - vb.net and a sample code
Posted by: Zeev Goldstein
Date: January 08, 2022 09:24AM

hello,
i'm new to this stuff
using VB.net i would like to renumber the primary index of a table and reset it to 1

found this code

SET @var_name = 0;
UPDATE ws_log SET linenum = (@var_name := @var_name +1);
ALTER TABLE ws_log AUTO_INCREMENT = 1

it works through Heidi
how do i implement it in VB.net?

or if there's any better way i will also appreciate it

many thanks

Options: ReplyQuote


Subject
Written By
Posted
help will be much appreciated - vb.net and a sample code
January 08, 2022 09:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.