Hello Lester,
Yes, I already done it. I tried to execute the SQL statement from PB IDE's
Database Administration Painter, and it's ok, i did not find any
problem/error, but if i ran it from PowerBuilder it always error.
Any solution ???
Thanks in advance,
Rendy
-----Original Message-----
From: Laforce, Lester [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 8:40 PM
To: '[EMAIL PROTECTED]'; PFC Mailing List (E-mail)
Subject: RE: PFCSIG SQL
Rendy,
I usually deal with embedded SQL problems by first copying and pasting the
SQL statement into the PB IDE's Database Administrator Painter. If it
statement executes correctly there, the source of your problem is probably
in the other parts of your code.
This will help you solve it by isolating its source because the problem area
has been broken into smaller units.
Lester LaForce
Sr. Software Developer
Armed Forces Institute of Pathology
United States Army
Washington DC
> -----Original Message-----
> From: Rendy Theixar [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, December 21, 2000 4:18 AM
> To: PFC Mailing List (E-mail); PB Mailing List (E-mail)
> Subject: PFCSIG SQL
> Importance: High
>
> Dear All,
>
> I am sorry this isn't PFC question. I have a problem with SQL command. I
> am
> using PB 6.5 and Sybase 12.
> Below is my script :
>
> ls_batch = '0003%'
> Insert Into glvouch0
> Select ffc_batchno, 'U', ffd_batchdate, :ls_bdesc,
> ffn_debitb,
> ffn_creditb,
> '', :ldt_lastdate, ffn_active, '2', 'A',:gs_userid,
> :ldt_lastdate,
> :gs_userid, :ldt_lastdate
> From apsljrn0
> Where ffc_batchno Like :ls_batch;
> If SQLCA.SQLCode <> 0 Then
> ls_errtext = SQLCA.SQLErrtext
> Rollback Using SQLCA;
> MessageBox("Error",ls_errtext)
> Return
> End If
>
> When, I ran my application, the program always error and prompt me :
> "ct_fetch(): user api layer: internal common library error: The bind of
> result set item 2 resulted in truncation"
>
> I think, the error because return value of that command more than 1 row,
> but
> it also happend if I change value for ls_batch,
> for example ls_batch = "0003JL0196"
>
> Can anyone help me to solve my problem ????
>
> Thanks in advance,
> Rendy Theixar
> * [EMAIL PROTECTED]
> Business System Development Department
> PT. Surabaya Agung Industri Pulp & Paper Tbk
>
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
