update test set ORDER = ?crsTest.ORDER, DETAIL = ?RTRIM(crsTest.DETAIL), INSTOCK = ?crsTest.INSTOCK, DETAIL2 = ?RTRIM(crsTest.DETAIL2) where PK = ?crsTest.PK...these two work:
update test set DETAIL = ?RTRIM(crsTest.DETAIL), INSTOCK = ?crsTest.INSTOCK, DETAIL2 = ?RTRIM(crsTest.DETAIL2) where PK = ?crsTest.PK...and...
update test set [ORDER] = 1, DETAIL = ?RTRIM(crsTest.DETAIL), INSTOCK = ?crsTest.INSTOCK, DETAIL2 = ?RTRIM(crsTest.DETAIL2) where PK = ?crsTest.PKIn resigned despeiration, I tried:
update test set [ORDER] = ?crsTest.[ORDER], DETAIL = ?RTRIM(crsTest.DETAIL), INSTOCK = ?crsTest.INSTOCK, DETAIL2 = ?RTRIM(crsTest.DETAIL2) where PK = ?crsTest.PK...to no avail.