Re-4: Declaring Cursor inside a loop

[Fabian Eschrich]

Hi Ruslan,


yes, Windows. Thanks alot.



Mit freundlichen Grüßen / kindly regards,

Fabian Eschrich
FAESCH Software

info at faesch.de
 
Fon:     +49 (0)37206 889293
Fax:     +49 (0)37206 889294
Skype:   feschrich

-------- Original Message --------
Subject: Re: Re-2: Declaring Cursor inside a loop (21-Aug-2008 7:54)
From:    Ruslan Zasukhin <sunshine at public.kherson.ua>
To:      valentina at lists.macserve.net

> On 8/20/08 7:40 PM, "Fabian Eschrich" <info at faesch.de> wrote:
> 
> Hi Fabian,
> 
> > Hi Ivan,
> > 
> > I reported it.
> > So for this time I simply splitted it in a procedure and a function. But 
> > there
> > I have a new problem:
> > 
> > DECLARE vCustomer_id VARCHAR(255);
> > DECLARE vTdate DATE;
> > DECLARE vNet double;
> > 
> >         DECLARE vcurTransactions CURSOR FOR select
> > getdate(TRANSACTIONS.tdate),TRANSACTIONS.NET,TRANSACTIONS.customer_id from
> > transactions;
> >                  
> >         OPEN vcurTransactions;
> > 
> >         BEGIN
> >             FETCH FIRST vcurTransactions INTO vTdate,vNet,vCustomer_id;
> > CALL 
> > SaveStatisticDoubleOnDateForAddress(vCustomer_id,vTdate,'transaction',vNet);
> > 
> > 
> > 
> > 
> > -- this is my declaration for function SaveStatisticsDoubleOnDateForAddress
> > CREATE OR REPLACE PROCEDURE [SaveStatisticDoubleOnDateForAddress]( IN
> > VADDRESSID VARCHAR, IN VDATE DATE, IN VNAME VARCHAR, IN VVAL DOUBLE )
> > 
> > 
> > But the log says:  18:40:37 Kernel error: 0x62501. Date value "2006-06-29" 
> > is
> > invalid. Illegal symbol at "3" position.
> 
> This means you try assign string with date value which not correspond to 
> the
> current settings of DateTime format.
> 
> Aha, just 2 days ago Ivan have made fix ... Similar issue to this one.
> 
> 
> You work on Windows, Fabian? Okay, today we will make new 3.6b34 for 
> Windows
> at least.
> 
> 
> -- 
> 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 mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>