Re: Does SQR Support SYBASE SQL Server 10.x?

[Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp]

Hello,

Thank you for your kind responces.

I had settlemented the probrem.

Thank you very much.

v   /u)/u)  v   Tomoaki Yamaguchi       CTC Support Center
 v (= ''=) ) v           E-Mail : Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp
v  (o   o)/ v===========================================================
 v  O---O    v                  We are seed of The Earth.

>Does SQR Ver2.5 support SYBASE SQL Server Version 10.x?
>
>I'm using SQR Ver2.5 to SYBASE SQL Server 10.0.1, the following problem
>occursed.
>
>    My Probrem --------------------------------------------------------
>
>        SQR Script
>                :
>            begin-procedure     proc_a
>
>                let #value = 2
>
>            begin-select
>            substring(col, 1, #value)   &res1
>            right(col, #value)          &res2
>            from    testdata_table
>            end-select
>
>            end-procedure
>                :
>    
>    The following error does occur when the execute SQR Script.
>
>        SQR Error File:
>           cale error during implicit conversion of NUMERIC value '1.2'
>           to a INT field.
>           SQL: select substring(col, 1,   1.2), right(col,   1.2)
>           from string_func_test
>             where 1 = 2
>
>             Error on line 37:
>                 (SQR 3716) Error in SQL statement.
>
>                Errors were found in the program file.
>        
>        SQR Command Syntax:
>
>            % sqr string_func.sqr sa/xxxx -S -Eresult -VSYBASE10
>        
>        Environment:
>
>            Platform : SPARC Station IPX
>            OS       : SunOS 4.1.3
>            SQR      : Ver2.5 EBF 1989
>
>            SYBASE SQL Server 10.0.1 EBF 2753
>    -------------------------------------------------------------------
>
>If you have any infomation. teach me please.