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

Re: SQR Insert

     Check the type of the last variable. I think it should be a numeric
     variable. You also must be getting some error on this type mis match.

     Rgds,
     Ganapati


______________________________ Reply Separator _________________________________
Subject: SQR Insert
Author:  "Janecek; Kevin J." <JANECKJ@AUS0000P01.AUST.TDPRS.STATE.TX.US> at
smtp_gw
Date:    7/9/98 10:44 AM


Hi guys,

I just subscribed to this user group and already have found some useful
information.  I have a question about SQR.

I currently have an SQR program which reads several tables and provides
detailed information along with sub-totals and totals.  Now, I want to take
these sub-totals and totals and insert them into a Statistics database
table.

I cant seem to get my Insert statement to work....any ideas?

My current statement is:
BEGIN-SQL

   INSERT INTO STAT_TABLE  (CD_STAT_PP_CODE,
                               CD_STAT_PP_REG,
                               CD_STAT_PP_UNIT,
                               NBR_STAT_PP_COUNT)
                values        ($stat_code,
                               $stat_reg,
                               $stat_unit,
                               $stat_count)

END-SQL

Thanks in advance,
Kevin