Visual Basic&database, How do I exclude duplicate database records

How do I exclude duplicate database records

Author	Message
Andreas Swensso #1 / 4	How do I exclude duplicate database records Quote: > Hi there, > I use VB 3.0 pro & Windows 3.1. and am cross posting in > comp.lang.basic.visual.misc. > I am trying to extract records from a database but want to exclude > duplicates. > I have read about the method/argument used for this exercise but can't > for the fife of me find it just when I need to use it. > Can someone point me in the right direction please. Use SQL and check in help for the sql statement DISTINCT. Andreas Swensson
Sun, 23 Apr 2000 03:00:00 GMT

Kenneth Le #2 / 4	How do I exclude duplicate database records Use distinct in your SQL query. Regards, Kenneth. Quote: >Hi there, >I use VB 3.0 pro & Windows 3.1. and am cross posting in >comp.lang.basic.visual.misc. >I am trying to extract records from a database but want to exclude >duplicates. >I have read about the method/argument used for this exercise but can't >for the fife of me find it just when I need to use it. >Can someone point me in the right direction please. >Many thanks in advance. >Frank White >Voice 61 8 9455 3475 >or 61 8 9455 3530 >Fax 61 8 9455 6767 >-------------------------------------
Sun, 23 Apr 2000 03:00:00 GMT

Decio Luczynsk #3 / 4	How do I exclude duplicate database records Use the select distinct SQl syntax: SELECT DISTINCT field1, field2, WHERE ..... Decio Quote: >Hi there, >I use VB 3.0 pro & Windows 3.1. and am cross posting in >comp.lang.basic.visual.misc. >I am trying to extract records from a database but want to exclude >duplicates. >I have read about the method/argument used for this exercise but can't >for the fife of me find it just when I need to use it. >Can someone point me in the right direction please. >Many thanks in advance. >Frank White >Voice 61 8 9455 3475 >or 61 8 9455 3530 >Fax 61 8 9455 6767 >-------------------------------------
Sun, 23 Apr 2000 03:00:00 GMT

Frank Whi #4 / 4	How do I exclude duplicate database records Hi there, I use VB 3.0 pro & Windows 3.1. and am cross posting in comp.lang.basic.visual.misc. I am trying to extract records from a database but want to exclude duplicates. I have read about the method/argument used for this exercise but can't for the fife of me find it just when I need to use it. Can someone point me in the right direction please. Many thanks in advance. Frank White Voice 61 8 9455 3475 or 61 8 9455 3530 Fax 61 8 9455 6767 -------------------------------------
Sun, 23 Apr 2000 03:00:00 GMT

Page 1 of 1

[ 4 post ]