Re: ACE Reports: running into record locks

Haven't tested this, but... create a procedure: create procedure sp_waitlock() returning smallint; set lock mode to wait;return 0; end procedure; and, in your ace report: select sp_waitlock() from systables where tabid = 1 into temp t_dummy with no log; >>> "Olmedo Monteverde" <o.monteverde@naville-livre.ch> 02/25/00 08:20am >>> There is no way to include the "set lock mode to wait" statement into an ace report. If your associate has the i4gl licence, he could convert the ace report into an 4gl program, where you can handle that statement. Hope it helps, OM <RSmith (R Smith)> a Tcrit dans le message : 8EE4B9020rsmithexpressnetcom@204.181.81.99... > One of my associates has chosen ACE as his reporting tool and > has written several reports. Many times they execute no problem, > other times they bomb when encountering a record lock. > > I believe that Informix opens the db in NO WAIT mode. > > In esqlc, I include the statement "EXEC SQL SET LOCK MODE TO WAIT 30", > but I don't see any options for the ACE reports. > > Any suggestions? > > Thank you. > > R Smith > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----