Help - at wits end :(

[Barry G. Sumpter]

Hi Eytan,

Thanks so much for the clarification and code example.

     Barry G. Sumpter


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
Sent: Tuesday, 10 July 2007 7:25 AM
To: Valentina Developers
Subject: Re: Help - at wits end :(

I have a timer that every 30 seconds does the following:

  if gConnection.IsConnected= true then
    
    tQueryString = "SELECT StudentID FROM Student WHERE StudentID = '1'"
        vres = gDB.SqlQuery( tQueryString )
  end if


If I didn't, gConnection would close, and while reopening it would not
generate any errors, I would run into Problems. I had no such problem when I
closed and opened the connection manually, but then I ran into other
problems.

Eytan

On 7/9/07 1:57 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Brilliant!
> 
> Could you expand on "tickle"?
> i.e. close and open or Select query?
> 
> Thanks,
>     Barry G. Sumpter
> 
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
> Sent: Tuesday, 10 July 2007 6:27 AM
> To: Valentina Developers
> Subject: Re: Help - at wits end :(
> 
> Trick proposed by my co-worker....
> 
> I have set up a 30 second times in Director, and I just "tickle" the
> database with a query once every 30 seconds. Seems to have resolved the
> problem.
> Eytan
> 
> 
> 
> On 7/9/07 12:03 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:
> 
>> Hi Eytan,
>> 
>> I have the same type of issues which may be completely unrelated.
>> 
>> I've posted warning reminders to myself on:
>> http://www.barrysumter.com
>> 
>> I would be very interested to know if find any of the warnings remotely
>> relevant.
>> 
>> Hth
>>      Barry G. Sumpter
>> 
>> -----Original Message-----
>> From: valentina-bounces at lists.macserve.net
>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
>> Sent: Tuesday, 10 July 2007 4:26 AM
>> To: Valentina Developers
>> Subject: Help - at wits end :(
>> 
>> I have an application that I am supposed to ship already. All the coding
> is
>> done, and everything seemed to work great.
>> 
>> I am using the V4MD Xtra, version 2.5.10
>> 
>> I can get info from the database all I want, and everything works. I can
> let
>> the program sit idle, click on a student in my application, and have
>> database queries work fine.
>> I can assign an activity to the students, creating a new record, and
>> everything works fine (again, all this using SQL queries)
>> I can then Querry the database the same way, and everything works fine.
>> 
>> However, if I let my program sit idle AFTER modifying the database, for
> more
>> than a minute or so, the application quits (either my app is I create a
>> runtime, or the director environment). It reports that the connection is
> no
>> longer open, I open it, and then havoc ensues. Note I am not CLOSING the
>> connection, and yet it closes.
>> 
>> Has anyone else seen this? Does anyone else know how to solve this? I am
>> about to add a timer to director that if no database queries are done for
> 59
>> seconds, I close the database, destroy the Valentina Xtra, and recreate
> it.
>> This is driving me crazy, I have been tackling it for a week now, with no
>> solution in site.
>> 
>> 
>> Please please please help
>> 
>> Eytan Bernet
>> McGraw-Hill Education
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina