Re: GNADE insert problem

[Jano <nono@celes.unizar.es>]

Robert I. Eachus dice...
> Jano wrote:
> 
> > I've workaround it disconnecting from the DB after each insert. Since I 
> > insert a record per minute and the db is local, it can hold that way 
> > until I get into the package you have suggested.
> 
> As an aside, this problem is why I quickly get headaches mixing Ada and 
> SQL.  SQL has this concept of an implicit cursor, and you have to be 
> very careful that every Ada thread containing SQL maintains its own 
> cursor correctly.

My program as a few tasks, but only one of them is making SQL calls 
(though now I think that maybe the initial connection is done from 
another task... room for some experimentation). Good to be warned 
though.

Kind regards,

Alex.