Hello,
How would I get the highest number from a column? The table has an ID column
but it does not auto imcrement and I have to do it manually so I need to get
the hihest integer value and increment it by one before adding data to the
dataset.
Thanks,
Grant
3  2177 
You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")
The filter is BS, it's just a condition that will always be false.
HTH,
Bill www.devbuzz.com www.knowdotnet.com
"Grant" <gp*****@hotmail.com> wrote in message
news:u3*************@TK2MSFTNGP11.phx.gbl... Hello,
How would I get the highest number from a column? The table has an ID
column but it does not auto imcrement and I have to do it manually so I need to
get the hihest integer value and increment it by one before adding data to the
dataset.
Thanks,
Grant
Thanks for your reply - Ill give it a go.
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:Oh**************@TK2MSFTNGP10.phx.gbl... You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")
The filter is BS, it's just a condition that will always be false.
HTH,
Bill
www.devbuzz.com
www.knowdotnet.com
"Grant" <gp*****@hotmail.com> wrote in message
news:u3*************@TK2MSFTNGP11.phx.gbl... Hello,
How would I get the highest number from a column? The table has an ID
column but it does not auto imcrement and I have to do it manually so I need to
get the hihest integer value and increment it by one before adding data to
the
dataset.
Thanks,
Grant
Thanks Bill that works.
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:Oh**************@TK2MSFTNGP10.phx.gbl... You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")
The filter is BS, it's just a condition that will always be false.
HTH,
Bill
www.devbuzz.com
www.knowdotnet.com
"Grant" <gp*****@hotmail.com> wrote in message
news:u3*************@TK2MSFTNGP11.phx.gbl... Hello,
How would I get the highest number from a column? The table has an ID
column but it does not auto imcrement and I have to do it manually so I need to
get the hihest integer value and increment it by one before adding data to
the
dataset.
Thanks,
Grant
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jaspreet |
last post by:
I was working on some database application and had this small task of
getting the second highes marks in a class. I was able to do that using
subqueries.
Just thinking what is a good way of...
|
by: Ada |
last post by:
hello folks,
is there a way to retrieve the highest value in the ArrayList?
let say i have a value in the array: {1, 4, 15, 3, 7}
it should return a value 15 as the result.
i've looked at...
|
by: enrique |
last post by:
Hello,
I simpy want to place a record ID into a session variable.
I know how to create session variables, I'm just can't figure out the syntax
for the record item when I'm working with a...
|
by: Neil |
last post by:
Hello everyone,
I am making a program at the moment, and need HELP!!!. I'll start
with the database, my field's r:
fldSku - which a 6 digit number, no more no less (145682)
fldDescription - which...
|
by: jaYPee |
last post by:
I have currently using a dataset to access my data from sql server
2000. The dataset contains 3 tables that is related to each other.
parent/child/grandchild relationship. My problem is it's very...
|
by: johnk |
last post by:
I have a table of items, with revision numbers. I need to extract the
items with highest revision number. The items may be listed several
times and I don't know what the highest revision number...
|
by: Joe |
last post by:
Hi
I am going to receive a dataset downstream and I will not know the
the fields
number of field
relations
number of relations
So I have to be flexible to take unknown data and be able to...
|
by: strife |
last post by:
Hi,
This is a homework question. I will try to keep it minimal so not to have anyone do it for me. I am really just stuck on one small spot.
I have to figure out the highest number from a users...
|
by: MyMarlboro |
last post by:
i wonder am i make a mistake or not...
use Data::Dumper;
my @array= qw(1 2 3 4 5 6 8 9 2 5);
my $highest=@array;
foreach my $number (@array) {
if (@array > $highest) {
$highest = @array;
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
