No Subject

["HALE, Nicole" <NHALE@BAEA.COM.AU>]

Hi Sylvain,

This is definitely the right place to ask such a question.

It sounds like you have the problem when you use $test inside the procedure.
Check that you are using it as the same data type within the procedure as in
the bit of code that assigns the value. If you need to swap from a character
to a number, make sure you do the correct conversion on the data first.

I hope this helps,

Cheers,

Nicole Hale
Analyst / Programmer
British Aerospace Australia
Contractors Area, East Avenue, DSTO Salisbury, SA  5108
PO BOX 1068, Salisbury, SA 5108
Tel:    +61 8 8290 7506 Fax:    +61 8 8290 8866
E-mail: nhale@baea.com.au <mailto:nhale@baea.com.au>



        -----Original Message-----
        From:   Sylvain Leclair [SMTP:sleclair@HOTMAIL.COM]
        Sent:   Thursday, July 29, 1999 3:49 AM
        To:     Multiple recipients of list SQR-USERS
        Subject:

        Hi everyone,


        I hope I'm at the right place to ask my question.

        I'm trying to make a SQR report which use a lot of procedure, table
and
        select. But I get this error from one of my procedure :

        (SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in cursor 6:
           [INTERSOLV][ODBC SQLBase driver]Data type for parameter 1 has
changed
        since first SQLExecute call.

        Error on line 329:
           (SQR 3723) Problem executing cursor.

        That come when I call a procedure with a parameter, which was taken
from an
        array, here my code :

        Let $test = PLAN.jobplan(#j)
        print $test (+10,1)
        do show_operation($test)

        This report will be run from MAXIMO, but for now It's only run from
        workbench. For those familiar with the subject, my report will print
all the
        equipment to be inspect in a route.

        I'm using SQR 4.1.1 for Win95, with a SQLBase platform, Maximo 4.01.
The
        computer is a Pentium 2-350 Mhz with 64 megs ram.

        I hope someone understand my problem and have a solution,

        Sylvain Leclair
        CiM Maintenance


        ______________________________________________________
        Get Your Private, Free Email at http://www.hotmail.com