Hi Bob, Thanks for the reply, as it is a small list of records I have taken the route you suggested using listByQuery() and it works fine.
Cheers Stephen On Jun 3, 10:27 am, Bob Silverberg <bob.silverb...@gmail.com> wrote: > 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 Silverbergwww.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 -~----------~----~----~----~------~----~------~--~---