Adding new fields

Klamp, Kurt Kurt.Klamp at abdnb.bayern.de
Tue Nov 16 13:34:38 CST 2004




>About duplicates. You need do next:
    
>    curs = db.SqlSelect( "SELECT DISTINCT name from T" )

>Now you have cursor with list of names that do not have duplicates.
With this i can not see recs with duplicate names, only unique names

Wouldn't it be better to do

	curs = db.SqlSelect( "SELECT DISTINCT name, count(name) from T" )

to see which names exists in which quantity ?.

Best,
Kurt
###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/


More information about the Valentina mailing list