Re: Why does this SQL Insert Fail

["Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>]

All the table fields are defined as VARCHAR (20)




-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Pete Helgren
Sent: Tuesday, November 24, 2009 11:15 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Why does this SQL Insert Fail

Is XmittalBatchNum truly a number or is it just a misnomer?  Unless 
there is formatting over it, the failure may be an issue with casting 
XX-6-20091102 to a number.

Just a WAG

Pete



Shannon ODonnell wrote:
> This is the statement and output:
>
>
>
> INSERT INTO TBH-Table ( XmittalBatchNum, TransmittalDate, Agency,
RB_UserID,
> CashAmountTotal, CheckAmountTotal, CreditAmountTotal, aCount ) 
>                        VALUES('XX-6-20091102', '11/2/2009 6:55:35 AM',
> 'Some_Agency', '2', '0.0000', '0.0000', '0.0000', '1')
>
>
> Unable to insert record: Transmittal Batch Num: XX-6-20091102
>
>
>
>
>
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
> Behalf Of MattLavinder@xxxxxxxxxxxxxxxxxxx
> Sent: Tuesday, November 24, 2009 10:50 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] Why does this SQL Insert Fail
>
>
> If you're getting any error messages that would be helpful.  If you remove
> the "or die(...)" you might get specific information on what is going on.
> I'd also like to see what your query looks like when you print it out.
>
>
>  
>
>