Re: SQR Insert

["Kearns, Gary" <KearnsG@HSN.NET>]

The SQL looks fine to me.  What kind of error are you getting?

Gary

Gary Kearns
HSN PeopleSoft Implementation
(813) 572-8585 x5070
kearnsg@hsn.net


> -----Original Message-----
> From: Janecek, Kevin J.
> [SMTP:JANECKJ@AUS0000P01.AUST.TDPRS.STATE.TX.US]
> Sent: Thursday, July 09, 1998 1:44 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      SQR Insert
>
> 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