Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: jared fernandez
  Where is jared fernandez?
 Caloocan City
 Philippines
 jared fernandez
 Tags
Subject: RE: Record No. 1
Thread ID: 189282 Message ID: 189287 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, August 14, 2008 9:22:22 AM         
   


> >
> > That sounds as if your Where condition sometimes may include more than the one row you want to update.
> > The easiest way might be "Replace" instead of SQL Update - because the active row in your grid always equals the record pointer position of the underlying alias.
> >
> > (The other way would be introducing a surrogate primary-key column (which is required when you want to use SQL anyway).)
> >
> >
> > hth
> > -Stefan
>
> Thanks stefan! But correct me if i'm wrong. Isn't "replace" command is for adding new data?

You're welcome. No, it is for replacing content in existing rows. The default scope is "Next 1", i.e. the current record.


hth
-Stefan

ENTIRE THREAD

Record No. 1 Posted by jared fernandez @ 8/14/2008 9:05:35 AM
RE: Record No. 1 Posted by Stefan Wuebbe @ 8/14/2008 9:16:06 AM
RE: Record No. 1 Posted by jared fernandez @ 8/14/2008 9:19:27 AM
RE: Record No. 1 Posted by Stefan Wuebbe @ 8/14/2008 9:22:22 AM
RE: Record No. 1 Posted by jared fernandez @ 8/14/2008 9:30:47 AM