Viewing 2 posts - 16 through 17 (of 17 total)
Never mind. I deleted everything and started over again from scratch today, and it all works as expected. Very mysterious!:unsure:
September 27, 2007 at 5:13 pm
#736972
I have found that either of the following methods work. The second is MUCH faster:
1.
UPDATE ISERIES.Serial#.Library.File
SET field1 = RTRIM(field1) + ' Changed' WHERE field2 = '00248000'
2.
UPDATE OPENQUERY(ISERIES, 'SELECT * FROM...
August 23, 2006 at 10:48 am
#656421