|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
February 27th, 2004, 12:46 AM
|
|||
|
|||
|
how to delete duplicate
hi there..
i have table in access like below postcode city state 41100 klang s'ngor 68000 klang s'ngor 41100 klang s'ngor 57000 gombak kl 28500 p.dlm kl 68000 klang s'ngor im using adodc to connect my access with vb and display it using data grid my problem is i want to create a rules that can delete duplicate entry..i want my program to be able to go through all the data from 1st row to the last row.. how can i do that..always stuck....thanx
|
|
#2
February 27th, 2004, 01:14 PM
|
|||
|
|||
|
One way is to open the database in Access itself and use the "find duplicates" wizard on your table. Then when the wizard is done, take a look at the SQL code Access generated to find the duplicated records (choose the SQL view).
You can often cut & paste this sql into your asp/vb code.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > how to delete duplicate |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
