>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 ;
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