<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>this method would require an 'orderby srt_item
descending' statement also - I always found it easiest to place it on the
access statement and let Axiant generate the open/fetch syntax </FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=joeboyle_adt@hotmail.com href="mailto:joeboyle_adt@hotmail.com">Joe
Boyle</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=sshahulgm@gmail.com
href="mailto:sshahulgm@gmail.com">Syed Shahul Hameed Mustaffa</A> ; <A
title=atla38@dsl.pipex.com href="mailto:atla38@dsl.pipex.com">Joe Boyle</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, November 30, 2005 4:58
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: GET VIAINDEX question</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I was just about to apologise for my naive
suggestion made earlier, and about to suggest you use a cursor with something
like the code below,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1. change the file to a cursor</FONT></DIV>
<DIV><FONT face=Arial size=2>2. add SQL clause like 'where ( via_item < :
request_item )'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and then you tell me that the suggestion
helped.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am truly astonished :))</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=sshahulgm@gmail.com href="mailto:sshahulgm@gmail.com">Syed Shahul
Hameed Mustaffa</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=atla38@dsl.pipex.com
href="mailto:atla38@dsl.pipex.com">Joe Boyle</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, November 30, 2005 3:00
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: GET VIAINDEX
question</DIV>
<DIV><BR></DIV>
<DIV>Dear Joe,</DIV>
<DIV> </DIV>
<DIV>I'm just now back from my vacation. </DIV>
<DIV> </DIV>
<DIV>Thank you so much for your help.</DIV>
<DIV>It resolved my issue.</DIV>
<DIV> </DIV>
<DIV>Best Regards,</DIV>
<DIV>SYED</DIV>
<DIV> </DIV>
<DIV><BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 11/30/05, <B class=gmail_sendername>Joe
Boyle</B> <<A
href="mailto:atla38@dsl.pipex.com">atla38@dsl.pipex.com</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">or if
processing many rows,</SPAN></FONT></P>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">While
ret GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item
Descending</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=3>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Joe
Boyle [mailto: <A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:atla38@dsl.pipex.com" target=_blank>atla38@dsl.pipex.com</A>]
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> 30 November 2005
12:59<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 'Syed Shahul
Hameed Mustaffa'; '<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:'powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A>'<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: GET VIAINDEX
question</SPAN></FONT></P></DIV>
<DIV><SPAN class=e id=q_107e146dbf67087e_1>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">How about trying
something like, </SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">GET
BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item
Descending</SPAN></FONT></P>
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,
Joe.</SPAN></FONT><FONT color=navy><SPAN style="COLOR: navy">
</SPAN></FONT></P></DIV>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=3>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
Syed Shahul Hameed Mustaffa [mailto: <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:sshahulgm@gmail.com" target=_blank>sshahulgm@gmail.com</A>]
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> 30 November 2005
12:41<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> GET VIAINDEX question
</SPAN></FONT></P></DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Dear
Gurus,</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Quick
Intro: I have migrated an PH/MPEIX application to AXIANT4GL/PH/WINDOWS
(THINCLIENT).</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">I
have a problem with the following GET statement</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">GET
BREED_SUMM_D viaindex BSD_BK using TCOMPUTER</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">The
GET command doesn't use the index.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">As
the backwards command doesn't work with relational databases, I created an
index call BSD_BK in the order i wanted.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">I'll
appreciate any effort to resolve this problem.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Thank
you somuch in advance.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Regards,</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">SYED.</SPAN></FONT></P></DIV></SPAN></DIV></DIV></BLOCKQUOTE></DIV><BR>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in
message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe:
"unsubscribe &lt;password&gt;" in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in
message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe
&lt;password&gt;" in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></BLOCKQUOTE></BODY></HTML>