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.

Insert from select

2 posts in General Discussion Last posting was on 2002-09-13 13:13:19.0Z
Manuel Posted on 2002-09-12 17:52:59.0Z
From: Manuel
Date: Thu, 12 Sep 2002 13:52:59 -0400
Newsgroups: ianywhere.public.general
Subject: Insert from select
Message-ID: <0F8461FE6BADE6C300623C4485256C32.00623C6285256C32@webforums>
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:615
Article PK: 2434

insert into trainingfrm(frmcode,
frmtitle,
analysisinstr,
matrix,
procstage,
qsf,
"lock",
status,
replace,
analysisname)
select 309,
frmtitle,
analysisinstr,
matrix,
procstage,
qsf,
0,
'N',
frmcode,
analysisname
from trainingfrm
where frmcode = 256 ;

gives the error "ASA Error-158: Value 256 out of range for destination"
There's no error if the value is less or equal 255.
I'm using ASA 8.0 and "frmcode" type is integer.


Robert Waywell Posted on 2002-09-13 13:13:19.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <0F8461FE6BADE6C300623C4485256C32.00623C6285256C32@webforums>
Subject: Re: Insert from select
Date: Fri, 13 Sep 2002 09:13:19 -0400
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <hbl1AlyWCHA.197@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:614
Article PK: 2431

What build number of ASA?
Is it 8.0.0 GA or something later?
- if you aren't on a current EBF, then I would recommend trying the
current EBF to see if it has already been fixed

Are you getting this error when you execute the statement in DBISQL or is it
from your front end application?
If it is from your application, what interface are you using to connect to
the database?


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Manuel> wrote in message
news:0F8461FE6BADE6C300623C4485256C32.00623C6285256C32@webforums...
>
> insert into trainingfrm(frmcode,
> frmtitle,
> analysisinstr,
> matrix,
> procstage,
> qsf,
> "lock",
> status,
> replace,
> analysisname)
> select 309,
> frmtitle,
> analysisinstr,
> matrix,
> procstage,
> qsf,
> 0,
> 'N',
> frmcode,
> analysisname
> from trainingfrm
> where frmcode = 256 ;
>
> gives the error "ASA Error-158: Value 256 out of range for destination"
> There's no error if the value is less or equal 255.
> I'm using ASA 8.0 and "frmcode" type is integer.