Member Avatar for ahmbil

Can somebody help me to update my Database automatically using Data control(data1).
I want to add 1 to all the value of one field so to automatically get the value of that field +1.

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by selvaganapathy
Member Avatar for selvaganapathy

Hi,
U can use UPDATE query to add one to all the records of one field. Ex Let say the fieldname be Age.
The Query is UPDATE TableName SET Age=Age+1 Or otherwise
U Iterate all the records and Add 1 to the field.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.