You cannot do that with Transfer, not in the way you suggest anyway. Transfer works with objects, not table rows, so you'd have to ask Transfer to get each object, update its property and then ask Transfer to save the object. You could use one of the listXXX methods to get a query that contains the records you are interested in, and then loop over that query, getting each object, etc.
If the expected number of records is small this will probably be fine, but if it may be a large number then you'd probably be better off just coding it in SQL. If you do go that route (using SQL) don't forget to discard the objects from the cache after you update them - otherwise your cache will be out of synch. Cheers, Bob On Tue, Jun 2, 2009 at 6:49 PM, stephend <stephend...@gmail.com> wrote: > > Hi, > > Been using for transfer for awhile now but this is the first time I > have had to update a group of records in a table. > This is easy in straight SQL but how do you do it with transfer. > > eg. Update tableName set defaultRec = "Y" where user = "xxxxx" > > Thanks. > > > > -- Bob Silverberg www.silverwareconsulting.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---