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 = x
Thanks.
- 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
Hi,
Is it possible to do something like this with the Transfer Query
Language ?
select d.*
from table d
inner join table2 s on d.id = s.id
the part I am interested in is select d.* I want all the fields for
just the one table in this case table d
or do I need to list all the properties of
Hi Mark,
Thanks for the quick reply, I will just do it the long way.
Stephen.
On Jul 17, 11:19 am, Mark Mandel mark.man...@gmail.com wrote:
Unfortunately no.. it's an annoying limitation of TQL in that.
Mark
On Fri, Jul 17, 2009 at 11:10 AM, stephend stephend...@gmail.com wrote