| Subject | Re: Update |
| From | Akshat Kapoor <akshat.kapoor@kapoorsons.in> |
| Date | Wed, 18 Oct 2017 15:14:36 +0530 |
| Newsgroups | dbase.getting-started |
> The updateAppend() method of the UpdateSet class that Bob wants to use > is quite a different animal to the XDML APPEND FROM and it works quite > differently. > > APPEND FROM simply adds records from one file to another. It doesn't > check to see if the record already exists in the target file or not. > > The append() method of the UpdateSet class does the same thing as APPEND > FROM. > > The UpdateSet class also has update() and updateAppend() methods which > work differently. > > To use update() or updateAppend() the target rowset must be indexed. The > help file only notes that for .dbf files this must be a "valid index" > but, as I see it, this should be an index on a primary key otherwise the > wrong record may be updated. Update() will look for a matching record > in the target table and update any changed fields. If it doesn't find a > matching record it does nothing. updateAppend() will update matching > records and will add a new record to the target table if a matching > record is not found. > > UpdateSet is great for copying data from a SQL server to .dbf files. Wow all this can be done in auto mode There is never an end to the learning process and I have barely started. I would have coded this step if required Regards Akshat | |