And don't forget the obvious. 1. Check database for damage with AUTOCHK
2. If it passes, back it up and rebuild indexes with PACK KEYS. David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, January 28, 2005 3:26 PM Subject: [RBG7-L] - Re: UPDATE COMMAND > 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 > > > > > > > > >
