Hi,
The driver-program should work fine with the ARGetListEntry()-api-call.
The important thing here is to minimize the impact on the target if you
have millions of records. That is why I specify one Query List Field where
I only return one byte.
Secondly I specify 1 as max entries returned.
You can still see the total count in "Number of matches: 174"
If your server does not allow unqualified searches, you might have to add
(1=1), or ('1' > 0) or something like that.
Command: gle
GETLIST ENTRY
Schema: testform
Qualifier Struct:
None, And, Or, Not, Relop or From Field (0, 1, 2, 3, 4, 5) (0):
Number of query list fields (0): 1
Entry list field entry
Field id (0): 1
Column width (20): 1
Separator ( ):
Number of sort fields (0):
First Retrieve (0):
Maximum number of entries to retrieve (500): 1
Get number of matches? (F): T
Use Locale for search? (F):
ARGetListEntry results
ReturnCode: WARNING
Entry List List : 1 items
Entry List Struct:
Entry Id : F00001
Short Description : F
Number of matches: 174
Status List : 1 items
Status Struct :
Message type : WARNING
Message number : 66
Message: The query matched more than the maximum number of entries
specified for retrieval
Command:
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> You should be able to use the Misc List SQL and put in SELECT COUNT(*)
> From T1920
>
> That will return 1 integer value
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Rick
> Sent: Tuesday, August 28, 2012 5:53 PM
> To: [email protected]
> 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. Using
> t1920, t1920;, 1920, didn't work either, so I thought I'd ask. I just
> need a fairly quick way to keep tabs on row counts.
>
> rp
>
> -----Original Message-----
> On 8/28/2012 3:00 PM, Pat Zandi wrote:
>> 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
>>
> -----Original Message-----
>> On Aug 28, 2012, at 17:53, Rick wrote:
>>
>>> 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 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
