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.

Error when running query in ADS Architect

2 posts in FoxPro Last posting was on 2003-11-05 21:47:10.0Z
Jon Griffith Posted on 2003-11-05 20:30:08.0Z
From: "Jon Griffith" <jmg@micromartinc.com>
Newsgroups: advantage.foxpro
Subject: Error when running query in ADS Architect
Date: Wed, 5 Nov 2003 13:30:08 -0700
Lines: 20
Organization: Micromart Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 69.28.137.98
Message-ID: <3fa95f0d@solutions.advantagedatabase.com>
X-Trace: 5 Nov 2003 13:35:25 -0700, 69.28.137.98
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.28.137.98
Xref: solutions.advantagedatabase.com Advantage.FoxPro:160
Article PK: 1109515

Not sure what this means, but in a dbf table I have a field that I need to
calculate based on another field.

Here is the query:

UPDATE ITEMS SET SELLPRICE1 = SELLPRIC - (SELLPRIC*.01) WHERE ACTIVE = 'T'

Now, the query actually works through the entire data set, but I get the
following error:

AdsQuery1: Error 7200: AQE Error: State = 01004; NativeError = 2102;
[Extended Systems][Advantage SQL Engine]Data truncated


I need to be able to continue the query for other fields by executing it as
a script, but not even one line will run without an error.

Any ideas?


Alex Wong (ADS) Posted on 2003-11-05 21:47:10.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: advantage.foxpro
References: <3fa95f0d@solutions.advantagedatabase.com>
Subject: Re: Error when running query in ADS Architect
Date: Wed, 5 Nov 2003 14:47:10 -0700
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 198.60.232.41
Message-ID: <3fa96e45@solutions.advantagedatabase.com>
X-Trace: 5 Nov 2003 14:40:21 -0700, 198.60.232.41
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.60.232.41
Xref: solutions.advantagedatabase.com Advantage.FoxPro:161
Article PK: 1109516

Replied in the general NG.

--
Alex Wong
Advantage R&D

"Jon Griffith" <jmg@micromartinc.com> wrote in message
news:3fa95f0d@solutions.advantagedatabase.com...
> Not sure what this means, but in a dbf table I have a field that I need to
> calculate based on another field.
>
> Here is the query:
>
> UPDATE ITEMS SET SELLPRICE1 = SELLPRIC - (SELLPRIC*.01) WHERE ACTIVE = 'T'
>
> Now, the query actually works through the entire data set, but I get the
> following error:
>
> AdsQuery1: Error 7200: AQE Error: State = 01004; NativeError = 2102;
> [Extended Systems][Advantage SQL Engine]Data truncated
>
>
> I need to be able to continue the query for other fields by executing it
as
> a script, but not even one line will run without an error.
>
> Any ideas?
>
>