Re: SPL: random integer

Check out www.iiug.org, I think there's randon number generator written in SPL there. If not check out the cdi archive 'cos I'm certain JL wrote and posted one a while back. Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678729 www.wfsoftware.com/informix # If you broke it, hide the evidence >>> "Toine Schijvenaars" <tsch00@pop3.nl.net> 08/30/99 12:57PM >>> Hi, We're developing an Web application with DDW, Webdatablade en Informix UDO 9.14 UC6. I'm writing a recursive SPL procedure in which I need a unique integer every time this procedure is invoked (also when it is called by itself). I tried two things: - To use a variable which was created using the 'current' function. But the this date (year to fraction) variable stays the same in the entire procedure call. - Create a temp table wit a serial8. Do inserts an request its number en delete it again. Problem: multi-user application, so the users are intefering with each other, while inserting en selecting. Is there another way to create a random integer. Toine Schijvenaars. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************