Re: Updating Primary Key

Hello friends, Thanks a lot to all of you for helping me solve the problem. Its very strange the problem was the keyword 'order'. I should have used some other word as the table name. But its very strange that 'select * from order' works fine, but 'update order ....' gives a syntax error. I have learned a good lesson, not to use keywords as variable/object names. BTW the system details are : Informix 7.24 UC4, HPUX 10.20 Thanks again. Vinod Bhansali Informix DBA DSL Transportation >From: Raj Muralidharan <raj.muralidharan@informix.com> >To: "Vinod Bhansali" <iiug@hotmail.com> >Subject: Re: Updating Primary Key >Date: Thu, 01 Jun 2000 06:48:36 -0400 > >I don't understand why you are having a problem. I am running the same set >of sql and not having an issue. What is your engine version. I am testing >mine on 9.20 but it shouldn't make a difference. I am wondering if your >script has a funny typo on that line. > >I am attaching my script. Tell me if this runs or not on your system. > >Raj ><< test12.sql >> > >%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% >Informix >Raj Muralidharan INFORMIX SOFTWARE Inc. >Principal Engineer 8065 Leesburg Pike >Advanced Technology Group Suite 700 >Tel: (703) 714-0606 Vienna, VA 22182 > (703) 847-2900 >Mobile: (703) 622-3541 >EFAX: (603) 584-0250 >FAX: (703) >714-0699 ><mailto:rmurali@informix.com>mailto:raj.muralidharan@informix.com > >Text Messaging: E-Mail to 7036223541@mobile.att.net (max 100 chars) > >%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Vinod Bhansali <iiug@hotmail.com> wrote in message news:8h63v2$4qi$1@news.xmission.com... > > Hello friends, > > Thanks a lot to all of you for helping me solve the problem. Its very > strange the problem was the keyword 'order'. I should have used some other > word as the table name. But its very strange that 'select * from order' > works fine, but 'update order ....' gives a syntax error. I have learned a > good lesson, not to use keywords as variable/object names. > > BTW the system details are : Informix 7.24 UC4, HPUX 10.20 This reminds me - we have at work at little database with a table called "release". When we upgraded to 7.23 the application using this stopped working. It was throwing a syntax error on: UPDATE release SET prog_status blah... This was fixed when I hacked the script to say: UPDATE "dba".release SET etc. -- Andrew Pearson: "exactly what the web needs less of".