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.

proxy table urgent

2 posts in General Discussion Last posting was on 2004-05-20 14:35:15.0Z
shif Posted on 2004-05-20 05:15:53.0Z
Sender: 59d7.40ac3931.1804289383@sybase.com
From: shif
Newsgroups: ianywhere.public.general
Subject: proxy table urgent
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40ac3f09.59ea.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 May 2004 22:15:53 -0700
X-Trace: forums-1-dub 1085030153 10.22.241.41 (19 May 2004 22:15:53 -0700)
X-Original-Trace: 19 May 2004 22:15:53 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3063
Article PK: 6523

Hi
I am using Adaptive sqlanywhere 7.0 .
I am facing problem while retrieving data from proxy table
in PB7.0 database painter and through datawindow.After
retrieveing
data from table it is always showing the error message
(SELECT EROR SQLSTATE S1000-Adaptive server anywhere general
error Backwords scrolling cursor s are not supported for
remote objects).
Some tables are not retrieving data also, only just showing
this
error mesasge.How an i solve this prblm,
But in ISQL it is working fine.
thanks in advance.


Robert Waywell Posted on 2004-05-20 14:35:15.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40ac3f09.59ea.1681692777@sybase.com>
Subject: Re: proxy table urgent
Lines: 48
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: 10.25.100.169
X-Original-NNTP-Posting-Host: 10.25.100.169
Message-ID: <40acc223$1@forums-1-dub>
Date: 20 May 2004 07:35:15 -0700
X-Trace: forums-1-dub 1085063715 10.25.100.169 (20 May 2004 07:35:15 -0700)
X-Original-Trace: 20 May 2004 07:35:15 -0700, 10.25.100.169
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3066
Article PK: 6526

You need to tell PB to use a forward only cursor to read from the proxy
table. Not sure how to force the datawindow to use a forward only cursor,
you might want to check that with the PB folks.

Note: The newsgroups are a user community, not a technical support channel.
Any time you need urgent assistance you should open a technical support case
under your support plan.

--
-----------------------------------------------
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://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

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

<shif> wrote in message news:40ac3f09.59ea.1681692777@sybase.com...
> Hi
> I am using Adaptive sqlanywhere 7.0 .
> I am facing problem while retrieving data from proxy table
> in PB7.0 database painter and through datawindow.After
> retrieveing
> data from table it is always showing the error message
> (SELECT EROR SQLSTATE S1000-Adaptive server anywhere general
> error Backwords scrolling cursor s are not supported for
> remote objects).
> Some tables are not retrieving data also, only just showing
> this
> error mesasge.How an i solve this prblm,
> But in ISQL it is working fine.
> thanks in advance.