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.

DW DTC error... table or view not found

3 posts in PowerSite specific Last posting was on 2001-07-04 21:22:55.0Z
gjl Posted on 2001-07-03 21:08:37.0Z
Newsgroups: sybase.public.powersite
From: "gjl" <jaya@compsystech.com>
Organization: 64.30.145.230
X-Newsreader: AspNNTP 1.50 (Advent 2000, Inc.)
Subject: DW DTC error... table or view not found
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Tue, 03 Jul 2001 17:08:37 -0400
Lines: 19
NNTP-Posting-Host: 207.156.232.111
Message-ID: <382_pDtuTRABBHA.205@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:169
Article PK: 862587

Trying to use the DW DTC i got this error: Warning: undefined variable
OBJECT1.cursor.EOF[EOF] near line 93 in "/first html page.htm" Warning:
undefined variable OBJECT1.cursor.GetValue[GetValue] near line 95 in "/first
html page.htm" Warning: undefined variable OBJECT1.cursor.MoveNext[MoveNext]
near line 104 in "/first html page.htm" Warning: undefined variable
OBJECT1.cursor.GetRowCount[GetRowCount] near line 119 in "/first html page.htm"

Error(-1):[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not
found: table 'COURSE' not found

Any ideas?,I am using ODBC connection to connect to oracle database.

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Patrick L. Li Posted on 2001-07-04 11:43:46.0Z
Newsgroups: sybase.public.powersite
From: "Patrick L. Li" <Lushu.Li@gnb.ca>
Subject: Re: DW DTC error... table or view not found
Date: Wed, 4 Jul 2001 08:43:46 -0300
Lines: 41
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 123.46.gnb.ca 142.139.123.46
Message-ID: <382_KAqNtHIBBHA.286@forums.sybase.com>
References: <382_pDtuTRABBHA.205@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:168
Article PK: 862588

I got same problem as you. I found there other guys also met such problem.
It seems a common problem but nobody answer or resolve it.

I located my problem at the following generated code segment:

......

sqlquery = "Error: DataWindow Query could not be found";
if (OBJECT1.sort) {
sqlquery += " ORDER BY " + OBJECT2.sort;
}
OBJECT1.cursor = OBJECT2.conn.CreateCursor(sqlquery);

.....

If use a correct SQL select statement replaces the string value of sqlquery,
Then OK. But I don't not know why Powersite don't generate the correct SQL
select statement. Who can answer this question?

gjl wrote in message ...
>
>Trying to use the DW DTC i got this error: Warning: undefined variable
>OBJECT1.cursor.EOF[EOF] near line 93 in "/first html page.htm" Warning:
>undefined variable OBJECT1.cursor.GetValue[GetValue] near line 95 in
"/first
>html page.htm" Warning: undefined variable
OBJECT1.cursor.MoveNext[MoveNext]
>near line 104 in "/first html page.htm" Warning: undefined variable
>OBJECT1.cursor.GetRowCount[GetRowCount] near line 119 in "/first html
page.htm"
>
>Error(-1):[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not
>found: table 'COURSE' not found
>
>Any ideas?,I am using ODBC connection to connect to oracle database.
>
>---== Posted via the PFCGuide Web Newsreader ==---
>http://www.pfcguide.com/_newsgroups/group_list.asp


gjl Posted on 2001-07-04 21:22:55.0Z
Newsgroups: sybase.public.powersite
From: "gjl" <jaya@compsystech.com>
Organization: 24.49.90.20
X-Newsreader: AspNNTP 1.50 (Advent 2000, Inc.)
Subject: Re: DW DTC error... table or view not found
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Wed, 04 Jul 2001 17:22:55 -0400
Lines: 45
NNTP-Posting-Host: 207.156.232.111
Message-ID: <382_rUU299MBBHA.260@forums.sybase.com>
References: <382_pDtuTRABBHA.205@forums.sybase.com> <382_KAqNtHIBBHA.286@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:167
Article PK: 862586

I replaced the sqlquery with the actual sql statement.Still it gives the error
as table 'course not found'
any idea???
gjl

On Wed, 4 Jul 2001 08:43:46 -0300,
in powersoft.public.powersite

Patrick L. Li <Lushu.Li@gnb.ca> wrote:
>I got same problem as you. I found there other guys also met such problem.
>It seems a common problem but nobody answer or resolve it.
>
>I located my problem at the following generated code segment:
>
>.......
>
>sqlquery = "Error: DataWindow Query could not be found";
>if (OBJECT1.sort) {
> sqlquery += " ORDER BY " + OBJECT2.sort;
>}
>OBJECT1.cursor = OBJECT2.conn.CreateCursor(sqlquery);
>
>......
>
>If use a correct SQL select statement replaces the string value of sqlquery,
>Then OK. But I don't not know why Powersite don't generate the correct SQL
>select statement. Who can answer this question?
>
>
>gjl wrote in message ...
>>
>>Trying to use the DW DTC i got this error: Warning: undefined variable
>>OBJECT1.cursor.EOF[EOF] near line 93 in "/first html page.htm" Warning:
>>undefined variable OBJECT1.cursor.GetValue[GetValue] near line 95 in
>"/first
>>html page.htm" Warning: undefined variable
>OBJECT1.cursor.MoveNext[MoveNext]
>>near line 104 in "/first html page.htm" Warning: undefined variable
>>OBJECT1.cursor.GetRowCount[GetRowCount] near line 119 in "/first html
>page.htm"
>>
>>Error(-1):[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not
>>found: table 'COURSE' not found
>>
>>Any ideas?,I am using ODBC connection to connect to oracle database.
>>
>>---== Posted via the PFCGuide Web Newsreader ==---
>>http://www.pfcguide.com/_newsgroups/group_list.asp
>
>

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp