RE: [Programmer-VB] Plz Help Me.V.V.Urgent - Find Duplicate Datas

Tue, 20 Sep 2005 03:03:23 -0700

 
Wow is working Thank your very much to all Guys and special to Heru
Thank you Very * 1000 much to ALL
This is what i expected.
 
 
 
 

Heru Rahadyan <[EMAIL PROTECTED]> wrote:
how about
trim(Place_Name)='america'
 
' may be it's not = 2 , but => 2... just in case there are more than 2
if retRows.Length=>2 then
   msgbox("Duplicate occured")
endif
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ashok Hari
Sent: Monday, September 19, 2005 8:00 PM
To: [email protected]
Subject: Re: [Programmer-VB] Plz Help Me.V.V.Urgent - Find Duplicate Datas

    I already tried to apply following trim conditions, But no use. i can't find out 'america' is occure two times even rows data contained america two times with front position of blank space like (****america *=blank space" ")
 
strCondition = "Place_Name=trim(Place_Name) and Place_Name='america'"
retRows=tblTable1.Select(strCondition)

Ronald Irawan <[EMAIL PROTECTED]> wrote:

Why don'y u use trim function ? *just curious

Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta


Ashok Hari <[EMAIL PROTECTED]>
Sent by: [email protected]

19/09/2005 09:52 PM

Please respond to
[email protected]
To
[email protected]
cc
Subject
[Programmer-VB] Plz Help Me.V.V.Urgent  - Find Duplicate Datas





Dear All,
 
   In my case i want to track the duplicate datas with in the VB.Net-datagrid is exist or not even the data contained blank spaces.
 
   plz let see the tow tables.
 
Table1
SNO        Place_Name
1             america
2             america****
 
 
Table2
SNO        Place_Name
1             america
2             ****america
 
Here consider *=blank space ie (" ")
 
Code1:
strCondition = "Place_Name='america'"
retRows=tblTable1.Select(strCondition)
if retRows.Length=2 then
   msgbox("Duplicate occured")
endif
 
This is working Fine. it's return retrows length=2 (i can track the duplicate data)
 
 
Code2:
strCondition = "Place_Name='america'"
retRows=tblTable2.Select(strCondition)
if retRows.Length=2 then
   msgbox("Duplicate occured")
endif
 
This is Not working it's return retrows length=1(i can not able to track the duplicate data)
 
My problem is very simple
 
    Using 'Select' statement i can not able to track or find whether the duplicate data is exist or not once the table data or string contained blank space in first position like (****america) . Please Help Me In this case how to Find the Duplicate datas. it's Very Very Urgent. i struggle soooo much.
 
Regards
H.Ashok
 
 

Yahoo! India Matrimony: Find your partner now.

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]

SPONSORED LINKS

Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language


YAHOO! GROUPS LINKS



Yahoo! India Matrimony: Find your partner now.

Yahoo! India Matrimony: Find your partner now.

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]



SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



Kirim email ke