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.

Querymode

3 posts in Appeon (partner product) Last posting was on 2005-02-25 20:12:44.0Z
Chuck Kahn Posted on 2005-02-21 16:03:53.0Z
From: "Chuck Kahn" <chuck.kahn@lmco.com>
Newsgroups: sybase.public.appeon
Subject: Querymode
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: edge1a.lmco.com
Message-ID: <421a0666$1@forums-2-dub>
X-Original-Trace: 21 Feb 2005 08:03:50 -0800, edge1a.lmco.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Feb 2005 08:03:52 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Feb 2005 08:03:53 -0800
X-Trace: forums-1-dub 1109001833 10.22.108.75 (21 Feb 2005 08:03:53 -0800)
X-Original-Trace: 21 Feb 2005 08:03:53 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:674
Article PK: 12651

I am starting to convert a PFC application to Appeon. It appears to me that
items like querymode which we use extensively throughout our application is
no longer available within the ACF version of the PFCs and PFEs. Is there a
reason that they pulled it out? Does this mean that I will need to convert
the PFC application to a non-PFC application in order to utilize querymode?

What are the advantages and disadvanges of converting a PFC application to a
non-PFC application for appeon?

Has anyone had any luck converting a PFC application to Appeon?

Thank you

Chuck


Rex Geissler Posted on 2005-02-25 20:12:44.0Z
From: "Rex Geissler" <Rex.Geissler@sybase.com>
Newsgroups: sybase.public.appeon
References: <421a0666$1@forums-2-dub>
Subject: Re: Querymode
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rgeisslexp.sybase.com
Message-ID: <421f86b7$1@forums-2-dub>
X-Original-Trace: 25 Feb 2005 12:12:39 -0800, rgeisslexp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Feb 2005 12:12:42 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Feb 2005 12:12:44 -0800
X-Trace: forums-1-dub 1109362364 10.22.108.75 (25 Feb 2005 12:12:44 -0800)
X-Original-Trace: 25 Feb 2005 12:12:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:682
Article PK: 12655

Hi Chuck,

DataWindow QueryMode is also planned for Appeon 3.0.

Regards, Rex

"Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
news:421a0666$1@forums-2-dub...
> I am starting to convert a PFC application to Appeon. It appears to me
that
> items like querymode which we use extensively throughout our application
is
> no longer available within the ACF version of the PFCs and PFEs. Is there
a
> reason that they pulled it out? Does this mean that I will need to
convert
> the PFC application to a non-PFC application in order to utilize
querymode?
>
> What are the advantages and disadvanges of converting a PFC application to
a
> non-PFC application for appeon?
>
> Has anyone had any luck converting a PFC application to Appeon?
>
> Thank you
>
> Chuck
>
>
>


Julie Jiang Posted on 2005-02-22 03:22:54.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <421a0666$1@forums-2-dub>
Subject: Re: Querymode
Lines: 145
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 210.21.221.178
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <421aa58e@forums-1-dub>
Date: 21 Feb 2005 19:22:54 -0800
X-Trace: forums-1-dub 1109042574 210.21.221.178 (21 Feb 2005 19:22:54 -0800)
X-Original-Trace: 21 Feb 2005 19:22:54 -0800, 210.21.221.178
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:675
Article PK: 20855

Hi Chuck,

You do not need to change the PFC application to non-PFC application at all.
If you have a PFC application, you may well stick to what it is and apply
Appeon ACF to convert it to the Web.

There are several ways for you to workaround the querymode in PFC.
Method 1: Use the PFC filter service or find service.

Method 2: Create a window to accept the WHERE criteria, the user enters the
criteria in the window instead of entering it in the DataWindow.
After modification, the user has to do the following steps to implement the
query operation.
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.

Method 3: (This method is strongly recommended. Once the of_query function
is defined, it works in a very similar way to querymode, and can be reused
for difference DataWindows.)
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.
There is a limitation with this method: 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 is the recommended
script 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

"Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
news:421a0666$1@forums-2-dub...
> I am starting to convert a PFC application to Appeon. It appears to me
that
> items like querymode which we use extensively throughout our application
is
> no longer available within the ACF version of the PFCs and PFEs. Is there
a
> reason that they pulled it out? Does this mean that I will need to
convert
> the PFC application to a non-PFC application in order to utilize
querymode?
>
> What are the advantages and disadvanges of converting a PFC application to
a
> non-PFC application for appeon?
>
> Has anyone had any luck converting a PFC application to Appeon?
>
> Thank you
>
> Chuck
>
>
>