From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM
	autolearn=ham autolearn_force=no version=3.4.4
X-Google-Thread: 103376,fc3719e6afe93cd7
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news1.google.com!postnews.google.com!i28g2000yqa.googlegroups.com!not-for-mail
From: tonyg <tonythegair@googlemail.com>
Newsgroups: comp.lang.ada
Subject: Re: mysql , gnade and function hanging
Date: Wed, 30 Jun 2010 02:40:25 -0700 (PDT)
Organization: http://groups.google.com
Message-ID: 
 <9e8008e5-129f-4b9b-b083-44b386a7ce4b@i28g2000yqa.googlegroups.com>
References: 
 <9d22007e-b11c-4527-afb5-ae429aeb3f05@c10g2000yqi.googlegroups.com>
	<e3e3d345-96ff-4f47-ab4d-02b5665c3742@u7g2000yqm.googlegroups.com>
	<773ca91b-2bcb-4b5e-9943-605a852d4dfd@t10g2000yqg.googlegroups.com>
	<1be70d43-a5f2-40cc-8859-f4e5d34bcd52@w12g2000yqj.googlegroups.com>
NNTP-Posting-Host: 89.240.135.62
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1277890825 14515 127.0.0.1 (30 Jun 2010 09:40:25
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 30 Jun 2010 09:40:25 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: i28g2000yqa.googlegroups.com; posting-host=89.240.135.62;
	posting-account=28F2IwkAAACL1Z5nRC-dE7zuvWdbWC7P
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/533.4
	(KHTML, like Gecko) Chrome/5.0.375.70 Safari/533.4,gzip(gfe)
Xref: g2news1.google.com comp.lang.ada:12032
Date: 2010-06-30T02:40:25-07:00
List-Id: <comp.lang.ada>

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 ...