Re: mysql , gnade and function hanging

[tonyg <tonythegair@googlemail.com>]

On 30 June, 10:29, tonyg <tonytheg...@googlemail.com> wrote:
> On 30 June, 10:23, Ludovic Brenta <ludo...@ludovic-brenta.org> wrote:
>
>
>
>
>
> > tonyg wrote on comp.lang.ada:
>
> > > On 30 June, 09:34, tonyg <tonytheg...@googlemail.com> wrote:
> > >> I am calling this gnade function in the mysql package to get some
> > >> debug info
>
> > >> Put_Line(To_String(String_Field (TheDatabase, TheHeaterQuery, 1)));
>
> > >> it unfortunately hangs though and the task stops
>
> > >> I am thinking perhaps the whole task has either hung or terminated
> > >> without telling me.
>
> > >> Would gnat tell me if this task had crashed?
>
> > > I put the code in a straight procedure and I get a constraint error
> > > which is
>
> > > raised CONSTRAINT_ERROR : gnu-db-mysql.adb:883 invalid data
>
> > > I am wondering what field types are good to use in a ada mysql
> > > database connection and what I am doing wrong here - has anybody any
> > > ideas ?
>
> > Looking at gnu-db-mysql.adb:883 (for gnade 1.6.1 or 1.6.2) indicates
> > that your variable TheHeaterQuery is not initialized.
>
> > --
> > Ludovic Brenta.
>
> Do you have some example code I can take a look at that retrieves a
> string from a database?

btw I use the Nbr_Of_Rows function and I get an answer of 2 which
indicates that the query has operated and retrieved the data correctly
and I try the query out in the mysql query browser to make sure the
query works so I do think the query has correctly initialised but its
when I go to access the string that things fall over. But I am very
confused about this problem as well ...