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.

Appeon Questions

3 posts in Appeon (partner product) Last posting was on 2004-09-15 07:13:28.0Z
Dimitris Karistinos Posted on 2004-09-14 10:15:09.0Z
Reply-To: "Dimitris Karistinos" <dkaris@relational.gr>
From: "Dimitris Karistinos" <dkaris@relational.gr>
Newsgroups: sybase.public.appeon
Subject: Appeon Questions
Lines: 23
Organization: Relational SA
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: relational.ath.forthnet.gr
X-Original-NNTP-Posting-Host: relational.ath.forthnet.gr
Message-ID: <4146c4ad@forums-1-dub>
Date: 14 Sep 2004 03:15:09 -0700
X-Trace: forums-1-dub 1095156909 213.16.181.99 (14 Sep 2004 03:15:09 -0700)
X-Original-Trace: 14 Sep 2004 03:15:09 -0700, relational.ath.forthnet.gr
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:407
Article PK: 20731

Hello group,
I am trying to migrate some old applications to Appeon but I have
encountered some problems so I need your help.

First of all my application uses 3 different menus according to som
selections done when the application starts. This means that there are 3
toolbars too. When I tried to run the web app produced I saw all the three
toolbars there. I searched the manuals about toolbars and could not find a
thing. Is it possible to have visible only the toolbar associated with the
menu?

My second question has to do with the query mode. Is it possible to use
query mode with appeon? If not are there any workoarounds?

Finally are getsqlselect and setsqlselect supported ?

Thank you for your time.

Kind regads

Dimitris Karistinos


Julie Jiang Posted on 2004-09-14 12:50:33.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 61.144.207.174
References: <4146c4ad@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Appeon Questions
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <4146e919$1@forums-1-dub>
Date: 14 Sep 2004 05:50:33 -0700
X-Trace: forums-1-dub 1095166233 64.79.161.40 (14 Sep 2004 05:50:33 -0700)
X-Original-Trace: 14 Sep 2004 05:50:33 -0700, web110.discountasp.net
Lines: 159
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:408
Article PK: 20729

Hi Dimitris,

Thanks for your interests in Appeon. Here are the feedback for your questions.

Issue #1: Set on or off of the toolbars
<ANS> This is supported by Appeon. You can find an example with this feature in
the Appeon Code Examples demo | PowerScript | Menu Techniques | MenuItem
Attributes. If you do not achieve the desired result, you need to specifically
debug the scripts related with toolbars. Here I have three suggestions: (1)
Refer to the relevant code in the Appeon Code Examples for how to get it
working; (2) Study the UFA report of the application, seeing what unsupported
features are used for the toolbars (menus); (3) Try to find the problematic code
by using the Appeon Developer Web Report tool (for how to use the Web Report
tool, refer to Chapter 9 in the Appeon Developer User Guide).

Issue #3: GetSqlSelect and SetSqlSelect
These two functions are supported in Appeon.

Issue #2: Query mode
Query mode is unsupported but does have workaround. See the workarounds below
(it is quite long because I copy the script of the workaround file here)
Workaround 1:

When the user wants to query, pop up a Query window in the application:

STEP 1 – Add a Query button. At the click of the Query button, a Query window
pops up.

STEP 2 – The user inputs query criteria in the Query window.

STEP 3 – After clicking Ok in the Query window, the current DataWindow only
displays the desired data.

Workaround 2:

Define an of_query function for the Datawindow (the script for the of_query
function is provided below). When the of_query function is executed, the
DataWindow retrieves data according to the WHERE criteria the user entered in
one or more columns.
There is a limitation with this method: the operators such as <, >, =, >=, <=,
<>, LIKE, IN, AND, and OR, can be recognized only in columns of Char, Date and
Time data type. For other columns, the only operator that can be used for
querying is "=".
The processes to work around QueryMode can be summarized in the following three
steps:
STEP 1 – Define an of_query function. The following are the recommended scripts
for the function:
datawindow ldw_obj
dwitemstatus ldwis_tmp
string ls_ret,ls_tmp,ls_colname,ls_dbname,ls_value,ls_oper,ls_coltype
integer i,j,li_row,li_col
choose case apo_obj.typeof()
case datawindow!
case else
return -1
end choose
ldw_obj = apo_obj
ls_ret = upper(ldw_obj.getsqlselect())
i = pos(ls_ret,"WHERE")
choose case i
case 0
case else
ls_ret = left(ls_ret, i - 1)
end choose
li_row = ldw_obj.rowcount()
li_col = integer(ldw_obj.object.datawindow.column.count)
for i = 1 to li_row
for j = 1 to li_col
ldw_obj.setrow(i)
ldw_obj.setcolumn(j)
ldwis_tmp = ldw_obj.getitemstatus( i,j,primary!)
choose case ldwis_tmp
case new!,newmodified!,datamodified!
ls_colname = ldw_obj.getcolumnname()
if ls_colname = "" or isnull(ls_colname) then
continue
if integer(ldw_obj.describe(ls_colname +
".visible")) = 0 then continue
ls_dbname = ldw_obj.describe(ls_colname + ".dbname")
ls_value = ldw_obj.gettext()

ls_oper = left(ls_value,2)
choose case ls_oper
case '>=','<=','<>'
ls_value =
right(ls_value,len(ls_value) - 2)
case else
ls_oper = left(ls_value,1)
choose case ls_oper
case '<','>','='
s_value =
right(ls_value,len(ls_value) - 1)
case else
ls_oper = " = "
end choose
end choose

ls_coltype = ldw_obj.describe( ls_colname +
".coltype")
choose case left(ls_coltype,4)
case 'char','date','time'
ls_value = '~'' + ls_value + '~''
end choose

ls_tmp = ls_tmp + ls_dbname + ' ' + ls_oper +
ls_value + " AND "
end choose
next
ls_tmp = left(ls_tmp,len(ls_tmp) - 4) + " OR "
next
ls_tmp = left(ls_tmp,len(ls_tmp) - 4)
if ls_tmp <> '' then ls_tmp = 'WHERE ' + ls_tmp
ls_ret = ls_ret + ls_tmp
i = ldw_obj.setsqlselect(ls_ret)
if i <> 1 then return i
li_row = ldw_obj.retrieve()
return li_row

STEP 2 – Place a Query button beside the DataWindow. In the Clicked event of
the Query button, add syntax similar to the following:

dw_1.reset()
FOR i=1 to n
w_1.insertrow(0)
NEXT
of_query(dw_1) //call to the of_query function

Regards,
Julie




On 14 Sep 2004 03:15:09 -0700,
in sybase.public.appeon

Dimitris Karistinos <dkaris@relational.gr> wrote:
>Hello group,
>I am trying to migrate some old applications to Appeon but I have
>encountered some problems so I need your help.
>
>First of all my application uses 3 different menus according to som
>selections done when the application starts. This means that there are 3
>toolbars too. When I tried to run the web app produced I saw all the three
>toolbars there. I searched the manuals about toolbars and could not find a
>thing. Is it possible to have visible only the toolbar associated with the
>menu?
>
>My second question has to do with the query mode. Is it possible to use
>query mode with appeon? If not are there any workoarounds?
>
>Finally are getsqlselect and setsqlselect supported ?
>
>Thank you for your time.
>
>Kind regads
>
>Dimitris Karistinos
>
>


Dimitris Karistinos Posted on 2004-09-15 07:13:28.0Z
Reply-To: "Dimitris Karistinos" <dkaris@relational.gr>
From: "Dimitris Karistinos" <dkaris@relational.gr>
Newsgroups: sybase.public.appeon
References: <4146c4ad@forums-1-dub> <4146e919$1@forums-1-dub>
Subject: Re: Appeon Questions
Lines: 187
Organization: Relational SA
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: relational.ath.forthnet.gr
X-Original-NNTP-Posting-Host: relational.ath.forthnet.gr
Message-ID: <4147eb98@forums-1-dub>
Date: 15 Sep 2004 00:13:28 -0700
X-Trace: forums-1-dub 1095232408 213.16.181.99 (15 Sep 2004 00:13:28 -0700)
X-Original-Trace: 15 Sep 2004 00:13:28 -0700, relational.ath.forthnet.gr
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:411
Article PK: 20733

Thank you for your prompt answer.....
Kind Regards

Dimitris Karistinos

"Julie Jiang" <julie.jiang@appeon.net> wrote in message
news:4146e919$1@forums-1-dub...
> Hi Dimitris,
>
> Thanks for your interests in Appeon. Here are the feedback for your
> questions.
>
> Issue #1: Set on or off of the toolbars
> <ANS> This is supported by Appeon. You can find an example with this
> feature in
> the Appeon Code Examples demo | PowerScript | Menu Techniques | MenuItem
> Attributes. If you do not achieve the desired result, you need to
> specifically
> debug the scripts related with toolbars. Here I have three suggestions:
> (1)
> Refer to the relevant code in the Appeon Code Examples for how to get it
> working; (2) Study the UFA report of the application, seeing what
> unsupported
> features are used for the toolbars (menus); (3) Try to find the
> problematic code
> by using the Appeon Developer Web Report tool (for how to use the Web
> Report
> tool, refer to Chapter 9 in the Appeon Developer User Guide).
>
> Issue #3: GetSqlSelect and SetSqlSelect
> These two functions are supported in Appeon.
>
> Issue #2: Query mode
> Query mode is unsupported but does have workaround. See the workarounds
> below
> (it is quite long because I copy the script of the workaround file here)
> Workaround 1:
>
> When the user wants to query, pop up a Query window in the application:
>
> STEP 1 - Add a Query button. At the click of the Query button, a Query
> window
> pops up.
>
> STEP 2 - The user inputs query criteria in the Query window.
>
> STEP 3 - After clicking Ok in the Query window, the current DataWindow
> only
> displays the desired data.
>
> Workaround 2:
>
> Define an of_query function for the Datawindow (the script for the
> of_query
> function is provided below). When the of_query function is executed, the
> DataWindow retrieves data according to the WHERE criteria the user entered
> in
> one or more columns.
> There is a limitation with this method: the operators such as <, >, =, >=,
> <=,
> <>, LIKE, IN, AND, and OR, can be recognized only in columns of Char, Date
> and
> Time data type. For other columns, the only operator that can be used for
> querying is "=".
> The processes to work around QueryMode can be summarized in the following
> three
> steps:
> STEP 1 - Define an of_query function. The following are the recommended
> scripts
> for the function:
> datawindow ldw_obj
> dwitemstatus ldwis_tmp
> string ls_ret,ls_tmp,ls_colname,ls_dbname,ls_value,ls_oper,ls_coltype
> integer i,j,li_row,li_col
> choose case apo_obj.typeof()
> case datawindow!
> case else
> return -1
> end choose
> ldw_obj = apo_obj
> ls_ret = upper(ldw_obj.getsqlselect())
> i = pos(ls_ret,"WHERE")
> choose case i
> case 0
> case else
> ls_ret = left(ls_ret, i - 1)
> end choose
> li_row = ldw_obj.rowcount()
> li_col = integer(ldw_obj.object.datawindow.column.count)
> for i = 1 to li_row
> for j = 1 to li_col
> ldw_obj.setrow(i)
> ldw_obj.setcolumn(j)
> ldwis_tmp = ldw_obj.getitemstatus( i,j,primary!)
> choose case ldwis_tmp
> case new!,newmodified!,datamodified!
> ls_colname = ldw_obj.getcolumnname()
> if ls_colname = "" or isnull(ls_colname) then
> continue
> if integer(ldw_obj.describe(ls_colname +
> ".visible")) = 0 then continue
> ls_dbname = ldw_obj.describe(ls_colname +
> ".dbname")
> ls_value = ldw_obj.gettext()
>
> ls_oper = left(ls_value,2)
> choose case ls_oper
> case '>=','<=','<>'
> ls_value =
> right(ls_value,len(ls_value) - 2)
> case else
> ls_oper = left(ls_value,1)
> choose case ls_oper
> case '<','>','='
> s_value =
> right(ls_value,len(ls_value) - 1)
> case else
> ls_oper = " = "
> end choose
> end choose
>
> ls_coltype = ldw_obj.describe( ls_colname +
> ".coltype")
> choose case left(ls_coltype,4)
> case 'char','date','time'
> ls_value = '~'' + ls_value + '~''
> end choose
>
> ls_tmp = ls_tmp + ls_dbname + ' ' + ls_oper +
> ls_value + " AND "
> end choose
> next
> ls_tmp = left(ls_tmp,len(ls_tmp) - 4) + " OR "
> next
> ls_tmp = left(ls_tmp,len(ls_tmp) - 4)
> if ls_tmp <> '' then ls_tmp = 'WHERE ' + ls_tmp
> ls_ret = ls_ret + ls_tmp
> i = ldw_obj.setsqlselect(ls_ret)
> if i <> 1 then return i
> li_row = ldw_obj.retrieve()
> return li_row
>
> STEP 2 - Place a Query button beside the DataWindow. In the Clicked event
> of
> the Query button, add syntax similar to the following:
>
> dw_1.reset()
> FOR i=1 to n
> w_1.insertrow(0)
> NEXT
> of_query(dw_1) //call to the of_query function
>
> Regards,
> Julie
>
>
>
>
> On 14 Sep 2004 03:15:09 -0700,
> in sybase.public.appeon
> Dimitris Karistinos <dkaris@relational.gr> wrote:
>>Hello group,
>>I am trying to migrate some old applications to Appeon but I have
>>encountered some problems so I need your help.
>>
>>First of all my application uses 3 different menus according to som
>>selections done when the application starts. This means that there are 3
>>toolbars too. When I tried to run the web app produced I saw all the three
>>toolbars there. I searched the manuals about toolbars and could not find a
>>thing. Is it possible to have visible only the toolbar associated with the
>>menu?
>>
>>My second question has to do with the query mode. Is it possible to use
>>query mode with appeon? If not are there any workoarounds?
>>
>>Finally are getsqlselect and setsqlselect supported ?
>>
>>Thank you for your time.
>>
>>Kind regads
>>
>>Dimitris Karistinos
>>
>>