Dawn, IDNO is integer. As you predicted, I did not get an error message, but I also didn't get the data updated. Paula -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dawn Hast Sent: Wednesday, July 15, 2009 11:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Help! Program that worked is now broken. Paula, This should get you by the syntax error, but doesn't explain the no rows exist. UPDATE fecuploadtemp SET frcode = biofile.frcode FROM fecuploadtemp, biofile WHERE biofile.idno = fecuploadtemp.idno Is idno an integer or text? Dawn
- [RBASE-L] - RE: Help! Program that worked is now broken. Dan Goldberg
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... Dan Goldberg
- [RBASE-L] - RE: Help! Program that worked is now brok... Dennis McGrath
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... John Minyo II
- [RBASE-L] - RE: Help! Program that worked is now brok... Dawn Hast
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... Dennis McGrath
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... Paula Stuart
- [RBASE-L] - RE: Help! Program that worked is now brok... Dennis McGrath
- [RBASE-L] - RE: Help! Program that worked is now brok... Javier Valencia
- [RBASE-L] - RE: Help! Program that worked is now brok... Stephen Markson
