Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 To: vaishali maske
  Where is vaishali maske?
 mumbai
 India
 vaishali maske
 Tags
Subject: RE: Process is slow
Thread ID: 268190 Message ID: 268891 # Views: 26 # Ratings: 0
Version: Visual FoxPro 6 Category: Projects and Design
Date: Thursday, July 15, 2010 8:55:13 AM         
   


replace all append blank to insert into...

warm regards,
mk.

> > if you want to update single record
> >
> > Your Original Code
> >
> >
> > **********************************
> > 
> > sele tmp2
> > append blank
> > 
> > replace cmember_no with tacc1.cmember_no
> > replace cgl_code with tacc1.cgl_code
> > replace csl_code with tacc1.csl_code
> > Replace ddoc_date with tacc1.ddoc_date
> > Replace cnarration with tacc1.cnarration
> > Replace Closing with bl
> > Replace FirstClose with bl
> > 
> > 

> >
> >
> > Change
> >
> >
> > **********************************
> > 
> > 
> > INSERT INTO tmp2 (cmember_no, cgl_code, csl_code, ddoc_date, cnarration, Closing, FirstClose) ;
> >    values (tacc1.cmember_no, tacc1.cgl_code, tacc1.csl_code, tacc1.ddoc_date, tacc1.cnarration, bl, bl)
> > 
> > 

> >
> >
> > warm regards,
> > mk.
> >
>
>
> Hello mk
>
> Thank you so much it processing fast after using insert into command.Thanks again.
>
> Regards,
> Vaishali

ENTIRE THREAD

Process is slow Posted by vaishali maske @ 7/9/2010 7:37:59 AM
RE: Process is slow Posted by Mike Yearwood @ 7/9/2010 4:01:16 PM
RE: Process is slow Posted by Tamar Granor @ 7/9/2010 10:51:02 PM
RE: Process is slow Posted by vaishali maske @ 7/10/2010 2:32:52 PM
RE: Process is slow Posted by Mike Yearwood @ 7/12/2010 6:57:53 AM
RE: Process is slow Posted by Tamar Granor @ 7/12/2010 10:45:13 PM
RE: Process is slow Posted by mk sharma @ 7/14/2010 9:53:16 AM
RE: Process is slow Posted by mk sharma @ 7/14/2010 10:11:00 AM
RE: Process is slow Posted by mk sharma @ 7/14/2010 10:26:41 AM
RE: Process is slow Posted by mk sharma @ 7/14/2010 12:06:16 PM
RE: Process is slow Posted by vaishali maske @ 7/15/2010 8:34:01 AM
RE: Process is slow Posted by mk sharma @ 7/15/2010 8:55:13 AM