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]
