Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


How to use insert into with two set


How to use insert into with two set

Author
Message
smart sout
smart sout
Forum God
Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)Forum God (3.1K reputation)

Group: Forum Members
Posts: 19, Visits: 94
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

GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search