Paul McNett wrote:
> MB Software Solutions wrote:
>
>
>>
>> I use a separate updatable cursor to update, so this shouldn't bite me.
>> When I go to update, I get the records via Primary Key and then do a
>> GATHER into that record and update it from the dirty cursor.
>>
>
> So why did you care about holding the connection open?
>
> Paul
>
>
Because I don't like the idea of open/close/open/close/open/close for
every stinking SQL. I wanted to maintain a live connection similar to
the concept used in MTS Server (although that memory is very foggy, so I
wouldn't wager it). I rope/lasso ("connection") per machine is my
goal....not several per PC per process.
I think I found the bug in my code. I should have tested the connection
and re-established it if the simple SQL failed. In my OP, I see that I
was missing that from the ELSE off the main IF in that routine.
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
