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.

Update dw error

10 posts in Appeon (partner product) Last posting was on 2006-12-11 14:40:20.0Z
MDT Posted on 2006-11-24 10:45:50.0Z
Sender: 23a1.4566d392.1804289383@sybase.com
From: MDT
Newsgroups: sybase.public.appeon
Subject: Update dw error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4566db6e.240b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Nov 2006 03:45:50 -0700
X-Trace: forums-1-dub 1164368750 10.22.241.41 (24 Nov 2006 03:45:50 -0700)
X-Original-Trace: 24 Nov 2006 03:45:50 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1665
Article PK: 21303

Hi,

Actually I'm trying a trial version of appeon, and I have to
migrate a powerbuilder application to the web.

I have a problem, when the client side try to do an update
in a dw with 2 fields cod (varchar(2)) and price
(decimal(2)) then the server gives an error message like:
[Microsoft][SQL SERVER 2000 Driver for JDBC][SQLServer]Less
columns in the INSERT instrucction than in the WHERE...

No changes made to database

insert into table_test(cod,price)
values('01',10,10)

it don't understand the decimal separator

I have searched in the appeon configuration server but I
didn't found nothing.

Thank you for the help


Vincent Yan Posted on 2006-11-27 02:11:05.0Z
Sender: 1cbd.4566458d.1804289383@sybase.com
From: Vincent Yan
Newsgroups: sybase.public.appeon
Subject: Re: Update dw error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <456a5749.7116.1681692777@sybase.com>
References: <4566db6e.240b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Nov 2006 19:11:05 -0700
X-Trace: forums-1-dub 1164597065 10.22.241.41 (26 Nov 2006 19:11:05 -0700)
X-Original-Trace: 26 Nov 2006 19:11:05 -0700, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1666
Article PK: 13093

Please notice that the SQL statement is incorrect. You are
trying to insert with three values to the two parameters.

insert into table_test(cod,price)
values('01',10,10)

Thus, the error message pop up indictating the
abover-mentioned SQL Statement error.

"......Less columns in the INSERT instrucction....."

Best Regards

> Hi,
>
> Actually I'm trying a trial version of appeon, and I have
> to migrate a powerbuilder application to the web.
>
> I have a problem, when the client side try to do an update
> in a dw with 2 fields cod (varchar(2)) and price
> (decimal(2)) then the server gives an error message like:
> [Microsoft][SQL SERVER 2000 Driver for
> JDBC][SQLServer]Less columns in the INSERT instrucction
> than in the WHERE...
>
> No changes made to database
>
> insert into table_test(cod,price)
> values('01',10,10)
>
> it don't understand the decimal separator
>
> I have searched in the appeon configuration server but I
> didn't found nothing.
>
> Thank you for the help


MDT Posted on 2006-11-27 06:53:29.0Z
Sender: 2726.4567010f.1804289383@sybase.com
From: MDT
Newsgroups: sybase.public.appeon
Subject: Re: Update dw error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <456a9979.748b.1681692777@sybase.com>
References: <456a5749.7116.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Nov 2006 23:53:29 -0700
X-Trace: forums-1-dub 1164614009 10.22.241.41 (26 Nov 2006 23:53:29 -0700)
X-Original-Trace: 26 Nov 2006 23:53:29 -0700, 10.22.241.41
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1667
Article PK: 13095

Hello,

Yes, I know, but It's a dw.update(), the same dw works
before the appeon migration, where can I configure the
decimal separator in appeon?

Thanks,

> Please notice that the SQL statement is incorrect. You are
> trying to insert with three values to the two parameters.
>
> insert into table_test(cod,price)
> values('01',10,10)
>
> Thus, the error message pop up indictating the
> abover-mentioned SQL Statement error.
>
> "......Less columns in the INSERT instrucction....."
>
> Best Regards
>
>
> > Hi,
> >
> > Actually I'm trying a trial version of appeon, and I
> > have to migrate a powerbuilder application to the web.
> >
> > I have a problem, when the client side try to do an
> > update in a dw with 2 fields cod (varchar(2)) and price
> > (decimal(2)) then the server gives an error message
> > like: [Microsoft][SQL SERVER 2000 Driver for
> > JDBC][SQLServer]Less columns in the INSERT instrucction
> > than in the WHERE...
> >
> > No changes made to database
> >
> > insert into table_test(cod,price)
> > values('01',10,10)
> >
> > it don't understand the decimal separator
> >
> > I have searched in the appeon configuration server but I
> > didn't found nothing.
> >
> > Thank you for the help


Adrian Parker Posted on 2006-11-27 11:28:23.0Z
From: "Adrian Parker" <apparker@nospam.nospam>
Newsgroups: sybase.public.appeon
References: <456a5749.7116.1681692777@sybase.com> <456a9979.748b.1681692777@sybase.com>
Subject: Re: Update dw error
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-Antivirus: avast! (VPS 0650-2, 23/11/2006), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 82-37-133-82.cable.ubr01.telf.blueyonder.co.uk
X-Original-NNTP-Posting-Host: 82-37-133-82.cable.ubr01.telf.blueyonder.co.uk
Message-ID: <456ad9e7@forums-1-dub>
Date: 27 Nov 2006 04:28:23 -0700
X-Trace: forums-1-dub 1164630503 82.37.133.82 (27 Nov 2006 04:28:23 -0700)
X-Original-Trace: 27 Nov 2006 04:28:23 -0700, 82-37-133-82.cable.ubr01.telf.blueyonder.co.uk
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1668
Article PK: 13094

I don't know how to solve your problem, but are you using the simple
javascript deployment or the Xcelerator one - I believe the Xcelerator
version is better at this than the js version.

<MDT> wrote in message news:456a9979.748b.1681692777@sybase.com...
| Hello,
|
| Yes, I know, but It's a dw.update(), the same dw works
| before the appeon migration, where can I configure the
| decimal separator in appeon?
|
| Thanks,
|
| > Please notice that the SQL statement is incorrect. You are
| > trying to insert with three values to the two parameters.
| >
| > insert into table_test(cod,price)
| > values('01',10,10)
| >
| > Thus, the error message pop up indictating the
| > abover-mentioned SQL Statement error.
| >
| > "......Less columns in the INSERT instrucction....."
| >
| > Best Regards
| >
| >
| > > Hi,
| > >
| > > Actually I'm trying a trial version of appeon, and I
| > > have to migrate a powerbuilder application to the web.
| > >
| > > I have a problem, when the client side try to do an
| > > update in a dw with 2 fields cod (varchar(2)) and price
| > > (decimal(2)) then the server gives an error message
| > > like: [Microsoft][SQL SERVER 2000 Driver for
| > > JDBC][SQLServer]Less columns in the INSERT instrucction
| > > than in the WHERE...
| > >
| > > No changes made to database
| > >
| > > insert into table_test(cod,price)
| > > values('01',10,10)
| > >
| > > it don't understand the decimal separator
| > >
| > > I have searched in the appeon configuration server but I
| > > didn't found nothing.
| > >
| > > Thank you for the help


MDT Posted on 2006-11-27 15:40:56.0Z
Sender: 2726.4567010f.1804289383@sybase.com
From: MDT
Newsgroups: sybase.public.appeon
Subject: Re: Update dw error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <456b1518.30b.1681692777@sybase.com>
References: <456ad9e7@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Nov 2006 08:40:56 -0700
X-Trace: forums-1-dub 1164645656 10.22.241.41 (27 Nov 2006 08:40:56 -0700)
X-Original-Trace: 27 Nov 2006 08:40:56 -0700, 10.22.241.41
Lines: 62
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1669
Article PK: 21302

Hello,

I'm using Xcelerator. Changing the regional configuration of
the server and client I've obtained that the numbers works
fine but now I've problems with the datetime fields

> I don't know how to solve your problem, but are you using
> the simple javascript deployment or the Xcelerator one -
> I believe the Xcelerator version is better at this than
> the js version.
>
>
> <MDT> wrote in message
> news:456a9979.748b.1681692777@sybase.com... | Hello,
> |
> | Yes, I know, but It's a dw.update(), the same dw works
> | before the appeon migration, where can I configure the
> | decimal separator in appeon?
> |
> | Thanks,
> |
> | > Please notice that the SQL statement is incorrect. You
> are | > trying to insert with three values to the two
> parameters. | >
> | > insert into table_test(cod,price)
> | > values('01',10,10)
> | >
> | > Thus, the error message pop up indictating the
> | > abover-mentioned SQL Statement error.
> | >
> | > "......Less columns in the INSERT instrucction....."
> | >
> | > Best Regards
> | >
> | >
> | > > Hi,
> | > >
> | > > Actually I'm trying a trial version of appeon, and I
> | > > have to migrate a powerbuilder application to the
> web. | > >
> | > > I have a problem, when the client side try to do an
> | > > update in a dw with 2 fields cod (varchar(2)) and
> price | > > (decimal(2)) then the server gives an error
> message | > > like: [Microsoft][SQL SERVER 2000 Driver for
> | > > JDBC][SQLServer]Less columns in the INSERT
> instrucction | > > than in the WHERE...
> | > >
> | > > No changes made to database
> | > >
> | > > insert into table_test(cod,price)
> | > > values('01',10,10)
> | > >
> | > > it don't understand the decimal separator
> | > >
> | > > I have searched in the appeon configuration server
> but I | > > didn't found nothing.
> | > >
> | > > Thank you for the help
>
>


Vincent Posted on 2006-11-28 01:49:38.0Z
Sender: 1cbd.4566458d.1804289383@sybase.com
From: vincent
Newsgroups: sybase.public.appeon
Subject: Re: Update dw error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <456ba3c2.dd9.1681692777@sybase.com>
References: <456b1518.30b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Nov 2006 18:49:38 -0700
X-Trace: forums-1-dub 1164682178 10.22.241.41 (27 Nov 2006 18:49:38 -0700)
X-Original-Trace: 27 Nov 2006 18:49:38 -0700, 10.22.241.41
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1673
Article PK: 21307

We'v understood what you mean and are working on your issue.
Thank you for your patience and bringing this to our
attention.

> Hello,
>
> I'm using Xcelerator. Changing the regional configuration
> of the server and client I've obtained that the numbers
> works fine but now I've problems with the datetime fields
>
>
>
> > I don't know how to solve your problem, but are you
> > using the simple javascript deployment or the
> > Xcelerator one - I believe the Xcelerator version is
> > better at this than the js version.
> >
> >
> > <MDT> wrote in message
> > news:456a9979.748b.1681692777@sybase.com... | Hello,
> > |
> > | Yes, I know, but It's a dw.update(), the same dw works
> > | before the appeon migration, where can I configure the
> > | decimal separator in appeon?
> > |
> > | Thanks,
> > |
> > | > Please notice that the SQL statement is incorrect.
> > You are | > trying to insert with three values to the
> > two parameters. | >
> > | > insert into table_test(cod,price)
> > | > values('01',10,10)
> > | >
> > | > Thus, the error message pop up indictating the
> > | > abover-mentioned SQL Statement error.
> > | >
> > | > "......Less columns in the INSERT instrucction....."
> > | >
> > | > Best Regards
> > | >
> > | >
> > | > > Hi,
> > | > >
> > | > > Actually I'm trying a trial version of appeon, and
> > I | > > have to migrate a powerbuilder application to
> > the web. | > >
> > | > > I have a problem, when the client side try to do
> > an | > > update in a dw with 2 fields cod (varchar(2))
> > and price | > > (decimal(2)) then the server gives an
> > error message | > > like: [Microsoft][SQL SERVER 2000
> > Driver for | > > JDBC][SQLServer]Less columns in the
> > INSERT instrucction | > > than in the WHERE...
> > | > >
> > | > > No changes made to database
> > | > >
> > | > > insert into table_test(cod,price)
> > | > > values('01',10,10)
> > | > >
> > | > > it don't understand the decimal separator
> > | > >
> > | > > I have searched in the appeon configuration server
> > but I | > > didn't found nothing.
> > | > >
> > | > > Thank you for the help
> >
> >