Re: update with clause first
"Jack Parker" wrote > And then ....(cut)..... They have ruined the internet. Absolutly ... That maybe not only the "spam things" that was responsible of all of this (Communication business play a big role in it ... web page take "hours" for loading now because a latence time of the advert server.) All thoses data sended to you , returned to the ad. sended back , ect.ect..... Anyway... Internet is no more like it used to be.... but that the evolution ===================================== > Arnaud, > > Replying from work, via webmail, so the reply doesn't work as well as my > normal mail reader. Look for "-" in front of where I wrote. No Problem :) As theres is an answer :) > Sorry - should have been more careful. The rownum is, of course, not there > in Informix, but you could add a serial column to the table entitled > 'rownum', and it will serve the same function. Well i can't touch the schema of the database.... I think i will write a C function, or me be a procedure that will intercept the thing.... Yes, I will think of that <cut> - can you describe what the application does? Maybe I could offer a suggestion if I understood it better. Well , that an warehouse management :) (i think you know about warehouse :) ) While the database is update by one task. Another one is tracking the state (trigger ,and all thoses things) and then read the table and start packing, preparing, etc..... all warehouse needed. 1) task one => update states in many row that's asking to task two to take care of these and start work on it. 2)when task two finish => task one know that and restart to update data when there is some time machine to work with it. => the table updated can contain many many rows. I think , that i need to rewrite a part of this code , for any databases instead of trying to make informix deal with it. > > > Although I've only advertised it about 1200 times on this group - OTOH, I > > wrote it so I wouldn't have to walk through it 1200 times. > > sorry for that.... and thk you for taking time to post it once again ...and > maybe again and again and again ..... :)) > > - I just meant that I've probably flooded the market - people are probably > tired of my mentioning the article. I swear, first time i'd heard about :) > - At one time it was fairly popular, I don't see a lot of people using it > anymore. that's what i guessed ... sadly for me
"hobbes" <pasdespam@yahoo.fr> wrote in message news:402b90e3$0$28664$626a14ce@news.free.fr... > > "Jack Parker" wrote > > > And then ....(cut)..... They have ruined the internet. > Absolutly ... > That maybe not only the "spam things" that was responsible of all of this > (Communication business play a big role in it ... web page take "hours" for > loading now because a latence time of the advert server.) > All thoses data sended to you , returned to the ad. sended back , > ect.ect..... > > Anyway... Internet is no more like it used to be.... but that the evolution > ===================================== > > Arnaud, One of the great things about being English is the ability to identify and delete spam immediately. I simply *know* that no-one called - to take a random sample from this afternoon - Bobbie, Sammy, Elva, Stuart Litel, Mallory, Dorothy, Dolly, Paige, Norberto, MaryAnn, Trey, MaryEllen, Avery, Milford, Garland, Concepcion, Sherman or anyone with an initial (eg Reba T Pierre) has any legitimate business writing to me, so I can simply delete it without further ado.
"Neil Truby" wrote > One of the great things about being English is the ability to identify and > delete spam immediately. > I simply *know* that no-one called - to take a random sample from this > afternoon - Bobbie, Sammy, Elva, Stuart Litel, Mallory, Dorothy, Dolly, > Paige, Norberto, MaryAnn, Trey, MaryEllen, Avery, Milford, Garland, > Concepcion, Sherman or anyone with an initial (eg Reba T Pierre) has any > legitimate business writing to me, so I can simply delete it without further > ado. > I would have bet the contrary ... Since French people (like me :)) , or non english one, do not know so much people that have "english sounded" name (i have absolutly no idea if this expression is valid ;) ). I can suppress with no remorse all the mail saying that : "my photo has arrived" (i have had so many photo made for the past 10 years that somebody must have interest in taking picture of me. :) I have certainly missed a lot of "job" , or money .... while deleting these english or russian mails ... but anyway .. No virus for past 10 years , (i admit that my job adress is protected by firewall and antivirus) ... no spam on my "parano'd" mail adresses... (do not try to send a mail to my private adress as Jack mention it it's against spam and i have NO mail adress on yahoo's database.) Personnal adresses are not protected ... But Outlook express is not used ... (i think that this one is responsible for the spam ...) The only mail adresses that was "mail bombed" is my web site mail adress, which i close definitly The last virus i have got was on amiga 15 years ago... And that was not by mail.. ;) Anyway , maybe a little out of topic ... But it's only one more messages contributing to the internet traffic. That's it ! Bye