Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: Update command working slow on Lan
Thread ID: 396165 Message ID: 396255 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, January 24, 2014 7:44:25 AM         
   


> >
> >
> >
> > Yes both tables has required tags (already created)
>
> Try this code, maybe it's quicker. No guarantee, but worth a try.
>
> 
> Select ItemNo from Sale_Tbl where Invoice_no = lnInvNo into cursor CurDummy nofilter 
> update Stk_Tbl set Chckd = .T. where ItemNo in (Select ItemNo from CurDummy)

>
> There's a fine line between helping and adding to the confusion.
>
> How to create sample data


Thanks


Added your code and testing the speed factor if any issue remain then consult with you

ENTIRE THREAD

Update command working slow on Lan Posted by Khurram Tahir @ 1/23/2014 8:02:21 AM
RE: Update command working slow on Lan Posted by Tore Bleken @ 1/23/2014 8:11:24 AM
RE: Update command working slow on Lan Posted by David Mustakim @ 1/23/2014 8:33:54 AM
RE: Update command working slow on Lan Posted by Khurram Tahir @ 1/23/2014 9:10:51 AM
RE: Update command working slow on Lan Posted by Tore Bleken @ 1/23/2014 9:30:45 AM
RE: Update command working slow on Lan Posted by Khurram Tahir @ 1/24/2014 7:44:25 AM