Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SCATTER TO oName ADDITIVE
Message
De
04/05/2006 15:23:14
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
 
 
À
04/05/2006 14:23:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01119312
Message ID:
01119337
Vues:
15
>I have a very small routine which scatters fields to a named object then gathers that information into another cursor which includes an additional field
>
>How do I add "notes" to the oFields object? Do I use oFields.AddProperty() ???
>
>
>SCAN
>   * assume that all these fields translate into curTable
>   SCATTER NAME oFields ADDITIVE
>
>   * assume that "notes" does not exist in the oFields object
>   * but "status" does
>   oFields.notes = oFields.status
>
>   * curTable wants to have "notes" inserted into it
>   INSERT INTO curTable FROM NAME oFields
>ENDSCAN
>
Borislav gave you the answer. But, here's a completely different approach:
SELECT curTable
APPEND FROM SourceTable

UPDATE curTable SET ;
  notes = status
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform