[RBASE-L] - Re: Update problem

[jan johansen]

maybe replace lt with <


-----Original Message-----
 From: TOM HART <tooma...@sbcglobal.net>
 To: rbase-l@rbase.com (RBASE-L Mailing List)
 Date: Fri, 31 Aug 2012 08:44:15 -0700 (PDT)
 Subject: [RBASE-L] - Update problem


I get an I/O error when I try to run:

update CommonCode set CCData = t2.CCData,CCModified = t2.CCModified+
 from CommonCode t1, tmpCode t2 where t1.CCName = t2.CCName+
 and t1.CCModified lt t2.CCModified

I am trying to update a code table if the modification date changes
CCData is the code=varchar
CCModified is DateTime stamp which I want use to update code

Both tables exist and I have modified CCModified so it will find data to 
update

Tom Hart