Re: expressions in insert

I do not know what is the reason for it but if you need to have expresions in inserts you could : prepare s_ins_stat from "INSERT J (COl1) VALUES (?)" execute s_ins_stat using current + 1 units day If U execute the insert several times prepare it only once ! ex : prepare ins foreach execute ins end foreach Mariusz Malogrosz mariuszm@tecsys.com Nigel Campbell (nigelc@Cognos.COM) wrote: : What is the reason behind Online not allowing the assignment of an : expression in an insert statement such as INSERT J (COl1) VALUES : (current + 1 units day) but allows the equivalent in an UPDATE : statement? : -- : Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707,Stn.T : Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr. : Cognos Incorporated Email: nigelc@cognos.com Ottawa ON K1G 4K9 : http://www.cognos.com CANADA : My comments are my personal opinion and are not the opinion of my employer or : anyone else. I claim copyright in all my statements and give noone the right : to copy them (even if they are quoted elsewhere) in any medium except on : netnews or email. In particular, noone can reproduce or reprint my comments in : print or any visual medium without getting my explicit permission.