Member Avatar for Parth_3

hii frnds
How can I increment a field without using Autonumber,like reading from its last value and then increment it?I'm new to vb.NET and really need a detailed explanation

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

You can do it with a simple query. For example

UPDATE myTable
   SET numHours = numHours + 1
 WHERE empid = 23

If you need more details on how to execute the query please provide more details such as type of database, table and field info, connection type. I don't know your level of expertise.

Edited by Reverend Jim
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.