Hi I am new to Vb6 programing. plz help me cn.Execute "update ctm set id=(id+1)where id =" & Val(Text1.Text)
he is work but i need use cn.Execute "update ctm set id=(id+1)where id =" & Val(Text1.Text) and id=(id)where id < " & val(text1.text)" how use the update in ... update the ctm table set the id field id add one if id = text1.text and donot add one if the id < text1.text plz help me i wait the reply bye
|