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.

Enquiries on config for supporting dynamic datawindows

5 posts in Appeon (partner product) Last posting was on 2006-10-30 07:54:55.0Z
Vicky Posted on 2006-10-25 09:13:25.0Z
Sender: 2934.45346db6.1804289383@sybase.com
From: Vicky
Newsgroups: sybase.public.appeon
Subject: Enquiries on config for supporting dynamic datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <453f2ab5.6af5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2006 02:13:25 -0700
X-Trace: forums-1-dub 1161767605 10.22.241.41 (25 Oct 2006 02:13:25 -0700)
X-Original-Trace: 25 Oct 2006 02:13:25 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1617
Article PK: 21285

Dear all,

I just read the appeon installation guide section 7.4 Config
for supporting dynamic DataWindows, and there's got some
question i don't understand, does anyone can help? many
thanks in advance.

Currently i am using...
PowerBuilder 10.2.1
Appeon 3.1 (3.1.1511.00) for PowerBuilder
MS SQL Server

1)...install the correspoidng SQL for the db.., does it mean
can create dynamic datawindow with syntaxfromSQL when
running the application on web?

2)I copy the code within and run it on my db, but it wasn't
success, it kept prompt me errors, i'd try to execute the
codes section by section, finally the store prod created
success, but still couldn't pass the testing section, does
anyone know how to run the text
file(install_appeon_syntaxfromsql_MSSQL.sql) success?

many thanks:)
vicky


tnomura Posted on 2006-10-27 01:36:16.0Z
Sender: 7d0d.45406964.1804289383@sybase.com
From: tnomura
Newsgroups: sybase.public.appeon
Subject: Re: Enquiries on config for supporting dynamic datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45416290.d34.1681692777@sybase.com>
References: <453f2ab5.6af5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Oct 2006 18:36:16 -0700
X-Trace: forums-1-dub 1161912976 10.22.241.41 (26 Oct 2006 18:36:16 -0700)
X-Original-Trace: 26 Oct 2006 18:36:16 -0700, 10.22.241.41
Lines: 69
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1620
Article PK: 13074

Hi vicky,

> Dear all,
>
> Currently i am using...
> PowerBuilder 10.2.1
> Appeon 3.1 (3.1.1511.00) for PowerBuilder
> MS SQL Server
>
> 1)...install the correspoidng SQL for the db.., does it
> mean can create dynamic datawindow with syntaxfromSQL when
> running the application on web?

Yes.

Script that worked on my pc. Appeon 3.1/PowerBuilder
9/WinXP
----------------------------------------------------------------------
string ERRORS, sql_syntax
string presentation_str, dwsyntax_str
sql_syntax = "SELECT * from employee"
presentation_str = "style(type=grid)"
dwsyntax_str = SQLCA.SyntaxFromSQL(sql_syntax, &
presentation_str, ERRORS)

IF Len(ERRORS) > 0 THEN
MessageBox("Warning", &
"Error occured with SyntaxFromSQL : " + ERRORS)
RETURN
END IF

dw_2.Create( dwsyntax_str, ERRORS)
IF Len(ERRORS) > 0 THEN
MessageBox("Warning", &
"Error occured with SyntaxFromSQL : " + ERRORS)
RETURN
END IF

dw_2.settransobject(sqlca)
dw_2.retrieve()
----------------------------------------------------------------------

>
> 2)I copy the code within and run it on my db, but it
> wasn't success, it kept prompt me errors, i'd try to
> execute the codes section by section, finally the store
> prod created success, but still couldn't pass the testing
> section, does anyone know how to run the text
> file(install_appeon_syntaxfromsql_MSSQL.sql) success?
>

Before doing "install_appeon_syntaxfromsql_MSSQL.sql",
SyntaxFromSQL failed with Appeon. But after doing above
sql, the
script started to work.

I had to do "install_appeon_syntaxfromsql_MSSQL.sql" against
my
database. I did it on the database "master" at first but
SyntaxFromSQL
failed with Appeon.
You can do it with isqlw.exe in the MS SQL Server binn
directory.
Change the defaut database master to your database with the
following
command or dropdown listbox on the menu bar of isqlw.exe.

use yourdababase
go


Yongqing.Yang Posted on 2006-10-27 03:53:48.0Z
Sender: f37.454182a0.1804289383@sybase.com
From: Yongqing.Yang
Newsgroups: sybase.public.appeon
Subject: Re: Enquiries on config for supporting dynamic datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <454182cc.f3b.1681692777@sybase.com>
References: <45416290.d34.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Oct 2006 20:53:48 -0700
X-Trace: forums-1-dub 1161921228 10.22.241.41 (26 Oct 2006 20:53:48 -0700)
X-Original-Trace: 26 Oct 2006 20:53:48 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1621
Article PK: 21276

I want to add 3 notes:

1. I recommend you executing
install_appeon_syntaxfromsql_MSSQL.sql after
uninstall_appeon_syntaxfromsql_MSSQL.
2. If a database server has multiple users, executing the
SQL file under the login of one user will be effective for
that user only. To make sure all users can use the
DataWindow data-caching feature, you should use different
logins to execute the SQL file.
3. When you execute the SQL for a database server, the
current login user of the server must have the right to
execute stored procedures and create functions.

If you have got error, could you add some detail information
of errors.

Regards,
Yongqing.Yang
Appeon Support Engineer