Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCATTER TO oName ADDITIVE
Message
From
04/05/2006 15:23:14
 
 
To
04/05/2006 14:23:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01119312
Message ID:
01119337
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform