Board index » Visual Basic

All times are UTC



 SELECT DISTINCT vs DISTINCTROW with dynaset 
Author Message
LMLins
#1 / 3
 SELECT DISTINCT vs DISTINCTROW with dynaset

 >What I am trying to do here is making the recordset to group some
 >records that have the same field value into ONE single row and edit ALL
 >the records from that single row. This is possible isn't it?

SELECT DISTINCT doesn't _group_ records so you can edit
all of them. Whatever gave you that idea?



Sat, 24 Jun 2000 03:00:00 GMT  
 
 Page 1 of 1
  [ 3 post ] 

 Relevant Pages 

1. Something like DISTINCT or DISTINCTROW, but what ?

2. difference between DISTINCT and DISTINCTROW (in a SQL query)

3. Something like DISTINCT or DISTINCTROW, but what ?

4. DISTINCT and DISTINCTROW in a SQL query?

5. Distinct or DistinctRow

6. SELECT DISTINCT problem (adVarWChar VS. adLongVarChar)

7. SELECT DISTINCT yields more than SELECT

8. Change SELECT to SELECT DISTINCT?

9. SELECT works, but SELECT DISTINCT fails

10. SELECT DISTINCTROW?

11. SELECT DISTINCTROW year(y) FROM x will not work properly

12. SELECT DISTINCT and memo field problem?

  

 
Powered by phpBB® Forum Software