VS eats my SP

[Barry G. Sumpter]

This is how to reproduce the error

Execute this in a sql tab


CREATE OR REPLACE PROCEDURE xxx( IN inValue long, Out outValue Long ) 
BEGIN
      IF inValue > 0 THEN
           inValue = CEIL(inValue);
      END IF
 END
 
 


Then
Execute this in another sql tab


 set @inValue = 1.59;
 call xxx( @inValue, @outValue );
 select @outValue;

the results are returned properly

in the 'number of records: 1'  result - click on the white space 
- and I get an error or VS freezes

I return to VS and stored procedures are not there.

Other times I create the stored procedure 
  - flush DB or restart VS or restart Winxp 
    - SP is still there    
       - then Execute the 2nd qry and same thing happens - error or freeze
            - then return to VS and the SP is gone

 
Hth

I'll have to drop my Valentina SP research for now 
as I need to move on to other more progressive assignments.





-----Original Message-----
From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Wednesday, 3 October 2007 4:50 PM
To: valentina-studio at lists.macserve.net
Subject: Re: valentina-studio at lists.macserve.net

On 3/10/07 8:10 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Still crashes on first execution after first create
> 
> -----Original Message-----
> From: valentina-studio-bounces at lists.macserve.net
> [mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
> Sumpter
> Sent: Wednesday, 3 October 2007 2:42 PM
> To: valentina-studio at lists.macserve.net
> Subject: valentina-studio at lists.macserve.net
> 
> VStudio v3.1 just ate my Stored Procedure.
> 
> Anyone else having this issue.
> 
> I'll see if I can install v3.4 on a virgin PC and play with Stored
> Procedures there.

Please send anything that can reproduce problem to me.

Or even better attach to report into Mantis.
    see our site, SUPPORT page


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio