Re: concurrency problems

>> From uunet!rmy.emory.edu!informix-list-owner Thu Sep 26 18:39:26 1991 >> From: Tony Heskett <uunet!lhr-sys.ssf-sys.DHL.COM!theskett> >> Subject: Re: concurrency problems >> To: informix-list@rmy.emory.EDU >> Date: Thu, 26 Sep 91 21:34:10 GMT-0:00 >> >> I've never been able to get these to work: >> >> ALTER TABLE foo LOCK MODE ROW;>> >> ALTER TABLE foo LOCK MODE PAGE, ROW; You need to enclose the lock mode in parens, e.g. ALTER TABLE foo LOCK MODE (ROW); It's correct in the current doc (4.1 SQLR), but I think the parens were left out of the prior versions. Note that this differs from CREATE TABLE. We were considering making them both consistent for 5.0, but there was resistance because it would break apps which relied on the original syntax. >> PS. Thanks to DAS for offering some *MUCH* better get_key() stuff. These appeared to be homegrown parallels of the new 4.1 4GL functions to do the same. 4.1 gives you the additional benefit of letting you specify "conceptual" keys regardless of the physical key assigned, e.g. you can specify fgl_keyval("accept") to check if the accept key is hit, regardless of what key is currently designated to be the accept key. >> Cheers - Tony. >> Tony Heskett: theskett@lhr-sys.ssf-sys.dhl.com | Vox: (+44) 81 747 8330 >> DHL Systems : Kings House, Great West Road, TW8 9HS | Fax: (+44) 81 747 0875 -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "I'm tough! When my girlfriend tells me that she doesn't want to see me anymore, I just poke her in the eyes!" "I'm tough! I'm into Punk Yoga. That's where you stand on *somebody else's* head!" "I'm so tough, when I go down to the beach, I kick sand in my *own* face!" "How do you make a dog 'meow'? You put it in the freezer for three days, take it out, and put it across a band saw. 'Meeeeeeeeeeeeeeeeeeowwwwwww'!" -- George Smilovich