I am TARDY for the PARTY but Yeah Danny you are correct:
select * from some_table where rownum = (some number you specify goes here)
Thanks For Letting Me Speak,
Mike
Date: Fri, 31 Aug 2012 18:29:17 +0200
From: danny.kell...@strategicworkflow.com
Subject: Re: driver.exe, row counts
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, August 30, 2012 8:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
One thing to remember ... Oracle does not support TOP, so I didn't think
Remedy would be using
properly. In fact I'm presenting one of those @ RUG this year :)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, August 29, 2012 10:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row
:)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, August 29, 2012 10:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Hi,
Well, this particular code might very
MDA/IC
Sent: Thursday, August 30, 2012 7:50 AM
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Misi,
I tend to agree with you, but in the last several years I found MANY things
that the Remedy server does poorly...I'll give you an example.
You need to get the sum of a particular
: driver.exe, row counts...
One thing to remember ... Oracle does not support TOP, so I didn't think Remedy
would be using it. (Is your example from the SQL log on the server?)
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC
Sent: August-30-12 09:04
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Yes...SQL...I'm curious how it handles the same situation in Oracle...
-Original Message-
From: Action
/ http://www.softwaretoolhouse.com/
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: August-28-12 23:03
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Hi,
The driver-program
I misunderstood your question last night Rick. I did the following today:
glsql
select count(*) from HPD_Help_Desk
[Enter] for the remaining questions
If all you need are counts it is must faster to do direct SQL calls than
GetListEntry, I would think. Use the names in the view instead of the T
thanks to everyone who replied!
r
On 8/29/2012 8:31 AM, Dale Hurtt wrote:
I misunderstood your question last night Rick. I did the following today:
glsql
select count(*) from HPD_Help_Desk
[Enter] for the remaining questions
If all you need are counts it is must faster to do direct SQL calls
Hi,
It might be faster, but it is direct SQL and may not work on any database...
Best Regards - Misi, RRR AB, http://rrr.se
I misunderstood your question last night Rick. I did the following today:
glsql
select count(*) from HPD_Help_Desk
[Enter] for the remaining questions
If
It might be faster, but it is direct SQL and may not work on any database...
select count(*) from HPD_Help_Desk
Does Remedy support a database where the above ANSI SQL won't work?
I suppose if ARS implements view names for their tables differently in another
database, it would not be
@ARSLIST.ORG] On Behalf Of Dale Hurtt
Sent: August-29-12 15:57
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
It might be faster, but it is direct SQL and may not work on any database...
select count(*) from HPD_Help_Desk
Does Remedy support a database where the above ANSI
Hi,
Well, this particular code might very well work across databases.
The other main concern with Direct SQL is that it is untraceable by the AR
System. The AR System does not understand what you are doing, and you can
not use AR tools to trace and analyze it in the same way as other
workflow.
Hi, everyone,
Is it possible to use driver.exe to determine row counts for a form?
I'm on 7.6.04 sp3, windows, ms sql.
Thanks,
Rick
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12
QQ: do you need this data outside of remedy cause you can just run a SQL line
count and put in a file on server? Vice calling from outside for the data? Just
wondering
Sent from my iPhone
On Aug 28, 2012, at 17:53, Rick r...@netfirst.com wrote:
Hi, everyone,
Is it possible to use
Thanks for the quick response.
I don't have access to the db, and can't introduce new code without
going through the change process. I was using driver.exe on another
task, and tried select count (*) from 1920, but that didn't work. Using
t1920, t1920;, 1920, didn't work either, so I
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Thanks for the quick response.
I don't have access to the db, and can't introduce new code without
going through the change process. I was using driver.exe on another
task, and tried select count (*) from 1920, but that didn't work
list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick
Sent: Tuesday, August 28, 2012 5:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: driver.exe, row counts...
Thanks for the quick response.
I don't have access to the db, and can't introduce new code without
going through the change
19 matches
Mail list logo