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: Samir Ibrahim
  Where is Samir Ibrahim?
 Chekka
 Lebanon
 Samir Ibrahim
 Tags
Subject: RE: UPDATE SQL Start from Second match
Thread ID: 209792 Message ID: 209823 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 12:44:27 PM         
   


> Hi Stefan,
>
> Although my problem is solved with Andres Answer, and sorry for not putting all the table structure, but I would like to know your idea
>
> CREATE CURSOR temp (p_auto_id I,p_id I, p_amount I, p_status L)
> INSERT INTO temp VALUES (1,1, 10, .F. )
> INSERT INTO temp VALUES (2,1, 36, .F. )
> INSERT INTO temp VALUES (3,2, 14, .F. )
> INSERT INTO temp VALUES (4,2, 58, .F. )
> INSERT INTO temp VALUES (5,2, 45, .F. )
> nID = 2
> nDisc = 1.5
> UPDATE temp SET p_amount = p_amount - nDisc,p_status = .t. WHERE p_id = nID and not p_status and p_auto_id > (Select TOP 1 p_auto_id from temp order by p_auto_id)
> BROWSE
>
> Can you fix it please?
>

As Andy pointed out, the sub-query in my suggestion would have needed a Where condition.
Because as we all pointed out, your sample data had no "sequence" column and no PK.
As you pointed out, Anders' solution is the fix, isn't it:
... And p_auto_id > (Select Min(p_auto_id) from temp Where p_id = m.nID)


So why pessimize it with a "Top 1" attempt? :-)
... And p_auto_id > (Select Top 1 p_auto_id from temp Where p_id = m.nID Order By p_auto_id)



-Stefan

ENTIRE THREAD

UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 10:54:20 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 11:25:26 AM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:36:14 PM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 12:44:27 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 11:42:18 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 11:54:02 AM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 11:59:20 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 12:08:57 PM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:39:59 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 4:39:59 PM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 1/1/2009 5:39:45 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 1/1/2009 7:42:36 PM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 1/2/2009 11:30:30 AM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 1/2/2009 10:15:20 AM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 12/31/2008 12:17:03 PM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:30:08 PM