Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing
Message
 
 
To
05/07/2001 14:57:50
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00523261
Message ID:
00527152
Views:
28
This message has been marked as a message which has helped to the initial question of the thread.
Jeffrey,

I've tried it right now, and I finally found a problem. Add the bolded lines:

>Hi Nadya,
>
>Having a problem here with your code. The select doesn't fire off and gives me the invalid command error... here's what i have...


>
>FOR i=1 to m.lnFields
>	IF !INLIST(FIELD(m.I), "PROJNO", "COMMENTS", "UNIQKEYSAS", "UNIQKEYBAY", ;
>		"YEAR", "NEWREC", "DISPUTE", "PRO_DATE", "DRAWDATE" )
>    	lcGroupBy=m.lcGroupBy+field(m.i)+iif(m.i=m.lnFields,'',',')
>	ENDIF
>ENDFOR
<b>
if right(m.lcGroupBy,1)=','
   lcGroupBy=left(m.lcGroupBy,len(m.lcGroupBy)-1)
endif   </b>
>select *, count(*) as cntDups ;
>	from tmpdbf ;
>	group by &lcGroupBy ;
>	having cntDups>=2 ;
>	into cursor curDups
>
> isduprec = .t.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform