Hi,
If i delete a record let 5 is the sr no.
now i want to do that the records arrange automatically 1,2,3,4,6,7,8 to 1,2,3,4,5,6,7
12345678 are the records.
I m using vb6 msaccess and ADODC
thanx
3  1013 
If i delete a record let 5 is the sr no.
now i want to do that the records arrange automatically 1,2,3,4,6,7,8 to 1,2,3,4,5,6,7
I think we need more info about what's in the records, and what they are being arranged by. For example, if the "sr no" is an AutoNumber field, then you cannot change the number, therefore once you delete "5" it's gone forever.
I think we need more info about what's in the records, and what they are being arranged by. For example, if the "sr no" is an AutoNumber field, then you cannot change the number, therefore once you delete "5" it's gone forever.
Hi,
I'm using ADO, VB6 and MS Access.
The sr field is not an AutoNumber, it is added manually.
Now I have delete it from VB6 app.
Now I want to arrange all sr nos as 1234567 instead of 1234 67
Thanx
... Now I have delete it from VB6 app.
Now I want to arrange all sr nos as 1234567 instead of 1234 67
Well, it seems as though the simplest thing would be to take the record with the highest number ( 7 in your example) and update it to 5, to fill the gap.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Kyle Root |
last post by:
I'm working on a little practice program, but I've become stuck and am
now utterly confused :?
I've created a jumble of python modules, in each one is a tuple that
goes something like,
deps =...
|
by: Ironside |
last post by:
Can someone give me a basic script example for arranging thumbnails on a page. I have always put them in tables that CSS is obviously better. Also, I like to put writing underneath the thumbnails...
|
by: NicK chlam via DotNetMonster.com |
last post by:
this is the error i get
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.Common.DbDataAdapter.Update(DataRow dataRows,
DataTableMapping tableMapping)
at...
|
by: bbernieb |
last post by:
Hi, All,
Is it possible to access a variable inside of a data binding, without the
variable being out of scope?
(Note: On the DataBinder line, I get an error message that says "Name 'i' is...
|
by: Gene |
last post by:
What can I do if I want to get the result using the sql command?
for example,
the select command is "select Name from Employee where StaffID=10"
How to get the "Name"???
dim Name as string
and...
|
by: michael |
last post by:
Hi All,
I'm trying to achieve an "ideal" of arranging the thumbnails
on one of my sites using only styles and divs, rather than a
table. I'm well practised with Divs etc, but a solution that...
|
by: shivaniem |
last post by:
I am doing a project in VB6 using oracle 8i i.e SQL plus as backend .
I have created a database with employee addresses.
while adding data through vb it was in a serial order. but in between when i...
|
by: dejavue82 |
last post by:
How would one best accomplish this in ASP.NET 2.0? I always thought
that a table would be best suited for this, however, these seem to be
SEO problems with this approach. Should I use CSS? And if...
|
by: Jerry Spence1 |
last post by:
I'm just wondering if there are any clever mathematicians out there.
My VB2005 program consists of a number of panels on a form. Here's the
rules:
The number of panels will be variable
The...
|
by: rei008 |
last post by:
well..i'm trying to make a code arrange my String arrays into something like this..don't know how to do it..hahah..
my Array size is actually 6 but i'm only using 5..don't know why..hahaha..
...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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: 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,...
| |
