Re-2: Declaring Cursor inside a loop

[Ruslan Zasukhin]

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]