Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset with Primary Key
Hello! I have recordset r with about 50 000 records. There are about 50%
duplicate records. I have idea to guckly removing duplicats: Next recordset r2 with Primary Key in field "x1". When I make update r2 from r, I think, I automtically resive records without duplicates. Unfornately, I can't make Primary Key for field. Is it possible? How make it and how make update r2 form r? Thanks! Dim r As ADODB.Recordset Set r = New Recordset For i = 1 To 3 r.Fields.Append "X" & i, adDouble, , adFldUpdatable Next i How to set Primary Index field(1) ("X1") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset with Primary Key
On Oct 7, 7:42*am, "Adax" wrote:
*Hello! *I have recordset r with about 50 000 records. There are about 50% duplicate records. I have idea to guckly removing duplicats: Next recordset r2 with Primary Key in field "x1". When I make update r2 from r, I think, I automtically resive records without duplicates. Unfornately, I can't make Primary Key for field. Is it possible? How make it and how make update r2 form r? Thanks! * * * * Dim r As ADODB.Recordset * * * * Set r = New Recordset * * * * * * For i = 1 To 3 * * * * * * * * r.Fields.Append "X" & i, adDouble, , adFldUpdatable * * * * * * Next i How to set Primary *Index *field(1) ("X1") Can you modify to some like SELECT DISTINCT <field FROM <table |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset with Primary Key
Uzytkownik "UglyChicken" napisal w wiadomosci
... On Oct 7, 7:42 am, "Adax" wrote: Hello! I have recordset r with about 50 000 records. There are about 50% duplicate records. I have idea to guckly removing duplicats: Next recordset r2 with Primary Key in field "x1". When I make update r2 from r, I think, I automtically resive records without duplicates. Unfornately, I can't make Primary Key for field. Is it possible? How make it and how make update r2 form r? Thanks! Dim r As ADODB.Recordset Set r = New Recordset For i = 1 To 3 r.Fields.Append "X" & i, adDouble, , adFldUpdatable Next i How to set Primary Index field(1) ("X1") Can you modify to some like SELECT DISTINCT <field FROM <table Thanks! But I don't have the table, I have only recordset. Is it possible without table get SELECT DISTINCT from Recordsetu? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating a primary key | Excel Discussion (Misc queries) | |||
(Primary) Key Column? | Excel Discussion (Misc queries) | |||
PRIMARY KEYS | Excel Programming | |||
Check for Primary Key | Excel Programming | |||
Type recordset/recordset? | Excel Programming |