Re: 4gl questions :

On 2 Oct 1997, Belakimem wrote: > Q1. If you declare an insert cursor and do multiple "puts", is it inefficient > to re-open the cursor before each put?. Yes, very. In fact, short of opening and closing the database each time, it would be hard to be less efficient. > Q2. Is there any harm in not closing open cursors, just reopening every time > they are needed? It depends on whether the code will ever need to work against a MODE ANSI database. If not, then it isn't critical, but it is a good idea to close the cursor when you finish with it (and FREE it if you won't use it very often); this cuts down on the memory needed in the engine. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>