Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Bind value for (?) is too big(23)

3 posts in Appeon (partner product) Last posting was on 2004-10-12 13:38:03.0Z
mark s Posted on 2004-10-11 16:45:21.0Z
Sender: 78a8.416ab86e.1804289383@sybase.com
From: Mark S
Newsgroups: sybase.public.appeon
Subject: Bind value for (?) is too big(23)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <416ab89d.78ac.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 11 Oct 2004 09:45:17 -0700, 10.22.241.42
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Oct 2004 09:45:18 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Oct 2004 09:45:21 -0700
X-Trace: forums-1-dub 1097513121 10.22.108.75 (11 Oct 2004 09:45:21 -0700)
X-Original-Trace: 11 Oct 2004 09:45:21 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:502
Article PK: 20773

Getting a SQL ReturnCode -1. The error text reads:

Bind value for (?) is too big(23)

Here is the watered down code:

UPDATE SpyNTAppSrvr.S800000A6

SET LASTNAMEX = :stu_lname_new
where STUDENTIDX = :stu_id
USING SQLCA;
MessageBox("SQL Code = ", SQLCA.SQLCode)
IF SQLCA.SQLCode = -1 THEN

MessageBox("SQL error", SQLCA.SQLErrText)
MessageBox("BIND PARAM", bind_param)

END IF

IF SQLCA.SQLCode = 0 THEN
MessageBox("SQL NOTE", "Update successful")
COMMIT USING SQLCA ;
END IF


Julie Jiang Posted on 2004-10-12 01:25:43.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 218.18.39.200
References: <416ab89d.78ac.1681692777@sybase.com>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Bind value for (?) is too big(23)
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <416b3293$1@forums-2-dub>
X-Original-Trace: 11 Oct 2004 18:25:39 -0700, web110.discountasp.net
Lines: 36
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Oct 2004 18:25:40 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Oct 2004 18:25:43 -0700
X-Trace: forums-1-dub 1097544343 10.22.108.75 (11 Oct 2004 18:25:43 -0700)
X-Original-Trace: 11 Oct 2004 18:25:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:503
Article PK: 20771

I would like to point out that the Appeon newsgroup is monitored by Sybase
and Appeon engineering staff who are very knowledgeable about Appeon issues.
Question that are purely PowerBuilder-related are best answered by the staff
and users of the PowerBuilder newsgroup: sybase.public.powerbuilder.XXXX.
Please post to the appropriate newsgroup so you receive the help you desire.

Regards,
Julie Jiang
Appeon Corporation

On 11 Oct 2004 09:45:21 -0700,
in sybase.public.appeon

<Mark S> wrote:
>Getting a SQL ReturnCode -1. The error text reads:
>
>Bind value for (?) is too big(23)
>
>Here is the watered down code:
>
>UPDATE SpyNTAppSrvr.S800000A6
>
> SET LASTNAMEX = :stu_lname_new
> where STUDENTIDX = :stu_id
> USING SQLCA;
> MessageBox("SQL Code = ", SQLCA.SQLCode)
> IF SQLCA.SQLCode = -1 THEN
>
> MessageBox("SQL error", SQLCA.SQLErrText)
> MessageBox("BIND PARAM", bind_param)
>
> END IF
>
> IF SQLCA.SQLCode = 0 THEN
> MessageBox("SQL NOTE", "Update successful")
> COMMIT USING SQLCA ;
> END IF


Matthew Chestnut Posted on 2004-10-12 13:38:03.0Z
From: Matthew Chestnut <matthew_chestnut at hotmail dot com>
Newsgroups: sybase.public.appeon
Subject: Re: Bind value for (?) is too big(23)
Message-ID: <6fnnm05fu2tbk4ssru4giq30vi3e44nj9r@4ax.com>
References: <416ab89d.78ac.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: atl1.firstwave.net
X-Original-Trace: 12 Oct 2004 06:38:01 -0700, atl1.firstwave.net
Lines: 18
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Oct 2004 06:38:01 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Oct 2004 06:38:03 -0700
X-Trace: forums-1-dub 1097588283 10.22.108.75 (12 Oct 2004 06:38:03 -0700)
X-Original-Trace: 12 Oct 2004 06:38:03 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:508
Article PK: 20775

One of the values (stu_lname_new or stu_id) is longer than the
database column type (lastnamex or studentidx).

On 11 Oct 2004 09:45:21 -0700, Mark S wrote:

>Getting a SQL ReturnCode -1. The error text reads:
>
>Bind value for (?) is too big(23)
>
>Here is the watered down code:
>
>UPDATE SpyNTAppSrvr.S800000A6
>
> SET LASTNAMEX = :stu_lname_new
> where STUDENTIDX = :stu_id
> USING SQLCA;
> MessageBox("SQL Code = ", SQLCA.SQLCode)