[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Does SQR Support SYBASE SQL Server 10.x?



Hello,

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.


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.