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-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,7179b046d1b6799f X-Google-Attributes: gid103376,public X-Google-ArrivalTime: 2003-12-31 07:42:48 PST Path: archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!in.100proofnews.com!in.100proofnews.com!cycny01.gnilink.net!cyclone1.gnilink.net!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Wed, 31 Dec 2003 09:42:46 -0600 Date: Wed, 31 Dec 2003 10:42:45 -0500 From: "Robert I. Eachus" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.lang.ada Subject: Re: GNADE insert problem References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: NNTP-Posting-Host: 24.34.214.193 X-Trace: sv3-REJ6ngisdAe/83pCEbVoas4YwcT6z4MfG+QH0kTBp/nV+IjTrLf251ABxkRgpgwD0S6AUhCTSI0uwP3!sdlF1hi871H45/k+WXIBZGnAvjIbGJnCq78EO2CZcnyoJCIxydmedQZWt6ziUg== X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: archiver1.google.com comp.lang.ada:3992 Date: 2003-12-31T10:42:45-05:00 List-Id: Michael Erdmann wrote: > Maybe there is some kind to simplifcation requiered for Ada 95 which > could be provided by GNADE? Anny sutiable interface you want to propose? ... > >>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. Maybe the best 'simplification' would be to define the SQL cursor/environment as a per task attribute. http://www.adaic.org/standards/95lrm/html/RM-C-7-2.html (Actually a pointer to the (potentially shared) enviroment would probably be the best implementation.) That way a user who needed to care could insure that either different tasks did have different (SQL) environments or shared a single environment. I don't see any way to get rid of the (mental) pain of those cases where you do need multiple active SQL cursors, but this way at least, the simpler cases can be dealt with. Of course, I would implement things so that there was a "default" environment that all tasks shared unless you explicitly changed the SQL environment for a task by opening an SQL session outside the environment task. (Note that the original poster is doing that, which puts him at best in a currently undefined situation.) The package that supports this could probably be made optional to accomodate any compilers that don't support per task attributes. -- Robert I. Eachus "The war on terror is a different kind of war, waged capture by capture, cell by cell, and victory by victory. Our security is assured by our perseverance and by our sure belief in the success of liberty." -- George W. Bush