Re: 4GL Cursors again

Nils.Myklebust@idg.no (Nils Myklebust) wrote: >afalout@zg.tel.hr (Andrej Falout) wrote: > (...big snip...) >:I want to avoid using FREE. I still have to support some V2 4gl >:compilers that does not have them. I can use only CLOSE. > >I think you have hit an absolute limit unless it helps to increase the >max. number of files each process can have open. Ooops, this is somethig new to me. Process = engine? Files=File system files like SE *.DAT & *.IDX? Please elaborate.... >Otherwise the only solution I can see given your limits (not using >free) is to create a function you can call that will create the >different statements in a char variable and use the same >prepare/declare to create the cursor as you need it. In this case you >can open the same cursor (one with the same name) in different >functions and in reality have totaly unrelated sql statements behind >it. It will *not* be nice (very bad programming practice), it will be >slow, but it should work. Of course you will have to be extremely >carefull not calling this common function while a cursor based on it >is open. You may need more than one such function to be able to avoide >that. Meaning I will have to prepare+declate+fetch everything, since simple "select * into var.* from x" directly in 4gl code is also a statement to the engine. Or not? >Another thing we did when we had this problem was to replace several >cursors with singleton sql statements where that was possible. It's >slow, but again it made the application work. > >I hope your customers will soon be able to upgrade to some later >engine. The world will be very much easier for you and them when they >can. I heard that one before, somewhere...., don't remember where. In this case, and not only this, it is my fault. I am unable to explane to them why 386 with 8 MB ram and 2*200MB HD and SE 2.x is unable to do the same job it was able to do for 7 years. They don't want it any faster. They don't want more users, or app's or anything. They have another server with OL7.x, and to them is all the same, ok, little (sic!) faster. They _only_ want me to keep supporting my own app. #%&$#%$&!!!!!!! Andrej. #include<std.disclaimer.h> **************************************************************** * Andrej Falout, RDBMS R&D, Croatia, Europe, afalout@zg.tel.hr * *--------------------------------------------------------------* * If you can read, You can do it ! * ****************************************************************