Bill: Some items to check: Create quick view of the 2 tables an see how many records you have (1605 or 1609) Are all the values on you link columns valid? Is the value passed valid in the receiving table? Do you have indices for the linking columns in both tables? Is so, try rebuilding the indices just in case there is corruption. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of William Owens Sent: Friday, January 28, 2005 1:22 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: UPDATE COMMAND I let the command run after getting syntax error and it updated 1605 rows out of 1609 At end of run I received message. ERROR-SYNTAX IS INCORRECT FOR THE COMMAND SET (2045) COLUMNS HAVE BEEN UPDATED IN 1605 ROWS IN BURIALS. I'm gong to check it out now.. Thanks all who responed. Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of William Owens Sent: Friday, January 28, 2005 1:46 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: UPDATE COMMAND Bill I still get syntax error and process seems to hang with hour glass I have to kill task. When I go back in some ownerids seem to be updated. Very strange -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bill Downall Sent: Friday, January 28, 2005 1:04 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: UPDATE COMMAND Bill, Try update burials set ownerid=t2.ownerid from burials, plotowners t2 where burials.plotloc = t2.plotloc Bill William Owens wrote: >I am trying to update a table "Burials" with an ownerid field from another >table "Plotowners" >Both tables have a field "Plotloc" which is a computed field >I use this command but I get a syntax error Would someone please correct >me??? > >update burials set ownerid=t2.ownerid from burials t1, plotowners t2 where >t1.plotloc = t2.plotloc > >Thanks > >Bill > > > >
