Re: SQR Insert

[Ray Brunner <rabrunne@AIS.SYR.EDU>]

Are you getting any error messages ?

> 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
>

*************************
Ray Brunner
rabrunne@syr.edu
443-9262
Syracuse University
*************************