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 Parsing Command

3 posts in Pocket PowerBuilder Last posting was on 2010-03-04 02:12:01.0Z
James Posted on 2010-03-03 03:50:47.0Z
Sender: 4d05.4b8dd875.1804289383@sybase.com
From: James
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Error Parsing Command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b8ddc97.4d40.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Mar 2010 19:50:47 -0800
X-Trace: forums-1-dub 1267588247 10.22.241.41 (2 Mar 2010 19:50:47 -0800)
X-Original-Trace: 2 Mar 2010 19:50:47 -0800, 10.22.241.41
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:12201
Article PK: 262072

Environment : PK 2.5.2 DB:UL10

Why My Ap is run ok within PK deployment environment, but
when deploy My Ap to PDA device, It is can't run within PDA
device ?

Error Message :

Datawindow Error
select error : Error parsing command: Unexpected
token in FROM clause, could not create table list.


My DataWindow SQL( has three retrieve arguments ) :
================================================================
select A.schedule_no as schedule_no, B.station as
start_site, C.code_name as start_site_nm, B.up_time,
end_site as end_site, D.end_site_name as end_site_nm,
D.arrive_time as arrive_time,
B.trn_arrow, A.trn_type, E.code_name, A.route, A.memo,
datediff( minute, left(B.up_time, 2
)+':'+right(B.up_time, 2), left(D.arrive_time, 2
)+':'+right(D.arrive_time, 2) ) as time_cost,
datediff(minute, convert(char(8), today(), 112) + ' ' +
left(B.up_time, 2 )+':'+right(B.up_time, 2),
convert(char(8), dateadd(day, 1, today() ), 112) +
' ' + left(D.arrive_time, 2 )+':'+right(D.arrive_time, 2) )
as time2_cost
from tbltrn_schedule A join
( select B.schedule_no as schedule_no, B.station as
end_site, C.code_name as end_site_name, B.arrive_time as
arrive_time,
B.station_id
from tbltrn_station B, tblcode_detail C
where B.trn_arrow = C.item_id and
B.station = C.code_id and
B.trn_arrow = :as_trn_arrow and
B.station = :as_end_site ) as D ( schedule_no,
end_site, end_site_name, arrive_time, station_id) on
(A.schedule_no = D.schedule_no),
tbltrn_station B, tblcode_detail C, tblcode_detail E
where A.schedule_no = B.schedule_no and
B.trn_arrow = C.item_id and
B.station = C.code_id and
A.trn_type = E.code_id and
E.item_id = 'T10' and
B.station_id < D.station_id and
B.trn_arrow = :as_trn_arrow and
B.station = :as_start_site

=================================================================

Thanks !!

James


Chris Keating (Sybase iAnywhere) Posted on 2010-03-03 13:41:46.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Error Parsing Command
References: <4b8ddc97.4d40.1681692777@sybase.com>
In-Reply-To: <4b8ddc97.4d40.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b8e671a$1@forums-1-dub>
Date: 3 Mar 2010 05:41:46 -0800
X-Trace: forums-1-dub 1267623706 10.22.241.152 (3 Mar 2010 05:41:46 -0800)
X-Original-Trace: 3 Mar 2010 05:41:46 -0800, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:12202
Article PK: 262069

Have you verified if this error occurs in DBISQL? Can you provide
schema needed to run this statement.

Also, the statement will likely complain about the "end_site as
end_site" column result as it occurs in both tbltrn_station and the
derived table. You will need to specify a correlation name.

-chris

On 02/03/2010 10:50 PM, James wrote:
> elect A.schedule_no as schedule_no, B.station as
> start_site, C.code_name as start_site_nm, B.up_time,
> end_site as end_site, D.end_site_name as end_site_nm,
> D.arrive_time as arrive_time,
> B.trn_arrow, A.trn_type, E.code_name, A.route, A.memo,
> datediff( minute, left(B.up_time, 2
> )+':'+right(B.up_time, 2), left(D.arrive_time, 2
> )+':'+right(D.arrive_time, 2) ) as time_cost,
> datediff(minute, convert(char(8), today(), 112) + ' ' +
> left(B.up_time, 2 )+':'+right(B.up_time, 2),
> convert(char(8), dateadd(day, 1, today() ), 112) +
> ' ' + left(D.arrive_time, 2 )+':'+right(D.arrive_time, 2) )
> as time2_cost
> from tbltrn_schedule A join
> ( select B.schedule_no as schedule_no, B.station as
> end_site, C.code_name as end_site_name, B.arrive_time as
> arrive_time,
> B.station_id
> from tbltrn_station B, tblcode_detail C
> where B.trn_arrow = C.item_id and
> B.station = C.code_id and
> B.trn_arrow = :as_trn_arrow and
> B.station = :as_end_site ) as D ( schedule_no,
> end_site, end_site_name, arrive_time, station_id) on
> (A.schedule_no = D.schedule_no),
> tbltrn_station B, tblcode_detail C, tblcode_detail E
> where A.schedule_no = B.schedule_no and


James Posted on 2010-03-04 02:12:01.0Z
Sender: 4fba.4b8df51d.1804289383@sybase.com
From: James
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Error Parsing Command
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b8f16f1.6dcf.1681692777@sybase.com>
References: <4b8e671a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Mar 2010 18:12:01 -0800
X-Trace: forums-1-dub 1267668721 10.22.241.41 (3 Mar 2010 18:12:01 -0800)
X-Original-Trace: 3 Mar 2010 18:12:01 -0800, 10.22.241.41
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:12203
Article PK: 262071

Hi Chris :

I change "end_site as end_site" to "D.end_site as
end_site", but the problem is still occur.

Now, I change my ap to use SA10, it's run fine.

Thanks !!

James

> Have you verified if this error occurs in DBISQL? Can you
> provide schema needed to run this statement.
>
> Also, the statement will likely complain about the
> "end_site as end_site" column result as it occurs in both
> tbltrn_station and the derived table. You will need to
> specify a correlation name.
>
> -chris
>
> On 02/03/2010 10:50 PM, James wrote:
> > elect A.schedule_no as schedule_no, B.station as
> > start_site, C.code_name as start_site_nm, B.up_time,
> > end_site as end_site, D.end_site_name as
> > end_site_nm, D.arrive_time as arrive_time,
> > B.trn_arrow, A.trn_type, E.code_name, A.route,
> > A.memo, datediff( minute, left(B.up_time, 2
> > )+':'+right(B.up_time, 2), left(D.arrive_time, 2
> > )+':'+right(D.arrive_time, 2) ) as time_cost,
> > datediff(minute, convert(char(8), today(), 112)
> > + ' ' + left(B.up_time, 2 )+':'+right(B.up_time, 2),
> > convert(char(8),
> > dateadd(day, 1, today() ), 112) + ' ' +
> > left(D.arrive_time, 2 )+':'+right(D.arrive_time, 2) ) as
> > time2_cost from tbltrn_schedule A join
> > ( select B.schedule_no as schedule_no, B.station
> > as end_site, C.code_name as end_site_name, B.arrive_time
> > as arrive_time,
> > B.station_id
> > from tbltrn_station B, tblcode_detail C
> > where B.trn_arrow = C.item_id and
> > B.station = C.code_id and
> > B.trn_arrow = :as_trn_arrow and
> > B.station = :as_end_site ) as D (
> > schedule_no, end_site, end_site_name, arrive_time,
> > station_id) on (A.schedule_no = D.schedule_no),
> > tbltrn_station B, tblcode_detail C,
> > tblcode_detail E where A.schedule_no = B.schedule_no and
>