Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 To: Steven Rebello
  Where is Steven Rebello?
 Bangalore
 India
 Steven Rebello
 Tags
Subject: RE: Index tag
Thread ID: 268944 Message ID: 268983 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 8:02:57 PM         
   


> >
> > What is your select query.
> >
> > Regards
> > Tushar
>
>
>
CREATE CURSOR curworkpending (copr c(3), cblock c(5), narea n(8,2), nPdgRds n(5),dfrmDate d(8),navghds n(5,2), navgPlnts n(5,2), nheads n(5,2), ntothds n(7,2),nSetTask n(5), dTskDate d(8)) 

>
>
>
INSERT INTO curworkpending (copr,cblock,narea,nPdgRds,dFrmdate,nheads,ntotHds,nAvgHds,nAvgPlnts) VALUES (lcopr,lcblock,lnarea, currounds.nrounds,currounds.frmdate,gnreqdhds,currounds.nrounds*ROUND(gnreqdhds,0),lnavghds,lnplants/lnavghds)

>
> (Please note gnreqdhds is not a public variable...just an old code variable)

That would only make one row, so of course you'd only get a unique value. Please stop and think about what you want.

Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.

ENTIRE THREAD

Index tag Posted by Steven Rebello @ 7/15/2010 3:05:30 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 3:39:13 PM
RE: Index tag Posted by Steven Rebello @ 7/15/2010 3:55:00 PM
RE: Index tag Posted by tushar @ 7/15/2010 4:25:54 PM
RE: Index tag Posted by Steven Rebello @ 7/15/2010 4:27:08 PM
RE: Index tag Posted by Samir H. @ 7/15/2010 5:12:09 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 8:02:57 PM
RE: Index tag Posted by Steven Rebello @ 7/17/2010 6:36:53 PM
RE: Index tag Posted by Mike Yearwood @ 7/18/2010 7:26:34 PM
RE: Index tag Posted by Steven Rebello @ 7/19/2010 4:40:52 AM
RE: Index tag Posted by Samir H. @ 7/19/2010 4:55:21 AM
RE: Index tag Posted by mk sharma @ 7/22/2010 8:05:53 AM
RE: Index tag Posted by Mike Yearwood @ 7/22/2010 5:34:21 PM
RE: Index tag Posted by Steven Rebello @ 7/22/2010 6:02:48 PM
RE: Index tag Posted by Mike Yearwood @ 7/22/2010 8:51:46 PM
RE: Index tag Posted by Steven Rebello @ 7/23/2010 3:26:30 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 6:51:50 PM