top is a SQL Server clause, it's not available in Oracle.
For Oracle, use this syntax:
select C1, Y, Z
from A
having rownum < 10
order by C1 asc
Axton Grams
On 1/25/07, L. J. Head <[EMAIL PROTECTED]> wrote:
** Ok....this leaves remedy space...and is entirely theoretical...but
should theoretically work...:)...and you didn't give a whole lot of
information about what your wanting to do with the data once you have
it...so YMMV
create a stored procedure that will first drop (if it exists) and then
create a db view of your ticket table that has a query along the lines of
select top N request_id from <form view>
order by requestid desc
where N is a variable passed into the stored procedure. Now create a
Remedy view form that points to that DB view....setup the stored procedure
to execute on button press (or whatever trigger you want) and you now have
access to do whatever you want with your data...one caveat of this is that
it is not 'thread safe'...in that if you have two users pressing that button
with different values for N....your screwed....and Remedy expects that the
view that your pointing at will be available at any time it wants...so the
moments between drop and re-create if the data is accessed in the Remedy
View form...you will get a DB error...
that is one possible way to get done what your looking for....it may not
work for you depending on your requirements....but maybe it will spark
interest or other ideas
------------------------------
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Richard Crosby
*Sent:* Thursday, January 25, 2007 8:56 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Ticket Query (part deux)
**
Hello,
I posted this question before and it did not elicit any responses.
Therefore, I asked BMC support and the response I received was, "I am sorry
I just dont know of a way you can limit the returned entires." (punctuation
and spelling errors left intact).
The question was:
How would I go about querying the last "N" tickets? Meaning, I'd like to
create a macro (or know the syntax) with a variable ("N") to pull up just
the last 10, 20, 50, 100 , etc. records recently created.
Can anyone help answer if this is do-able or not?
Thanks,
Richard
__20060125_______________________This posting was submitted with HTML in
it___
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
