Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update syntaxe for a stock programmation.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01228160
Message ID:
01228203
Vues:
24
This message has been marked as the solution to the initial question of the thread.
You have to use LEFT JOIN in order to upadte all records in the v_AgendaPhar. With INNER JOIN the records in v_AgendaPhar that don't have matching records in derived table pd will not be updated.
  UPDATE v_AgendaPhar  ;
      SET nstkjour = NVL( pd.nStkjourCor , 0 ) +1 ;
    FROM v_AgendaPhar;
      LEFT JOIN(;
        SELECT apd.nstkjour AS nStkjourCor , apd.itraiterId ;
          FROM  AgendaPhar apd ;
          WHERE apd.iagendadateid < vp_id ) pd ;
    ON v_AgendaPhar.itraiterId = pd.itraiterId
>
>I have many problems to know the stock of previous days.
>I want for the day ( iagendadateid = 2 ) the stock of ( iagendadateid = 1 ) + 1
>
<snip>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform