Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 11th, 2006, 11:27 AM
Authorized User
Join Date: Sep 2006
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default Add 1 to next column

I really need some help with this one.
This is my problem I have a program in which I enter person(s) names in a database on a daily basis. I have 3 columns an Identification Column, a Name column, and a Number column. When the program is ran it automatically puts a 1 in the numerical column of the first Identifiaction Colunm. And the stored procedure calls for the name with that has a 1 in the numerical column. When I press next. I want to add a 1 to the next person in the database and change the current person with the 1 to zero. So no matter who presses next, the program will pull only the person with the 1 in the numerical column. I know i need some type of loop because when the list gets to the end of the database it needs to start back at the top..

Can anyone help??

Alexander Nelson
Alexander Nelson
Old December 13th, 2006, 08:29 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi

can you point out an example???


Old December 18th, 2006, 01:42 PM
Authorized User
Join Date: Oct 2006
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts

I don't know what you're talking about.:(

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add a new column into gridview? Bryan Stanley ASP.NET 2.0 Basics 0 September 12th, 2007 10:49 PM
Add a Column to a DataGrid infernokodiak C# 7 January 18th, 2006 04:06 PM
Add Column in a View rekha_jsr Oracle 1 December 5th, 2004 04:58 AM
how to add new column to recordset?? huela Access VBA 0 October 13th, 2004 01:22 PM
add column (C#) kobystud C# 1 July 21st, 2004 10:58 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.