Search results for query: *

OU18, You can create a regular form that we'll call NEXT_CIRCUIT. On that form, create a field 'Next Circuit ID'. There will only be one record in this form, and the value in the 'Next Circuit ID' field will always be the next circuit ID to be assigned. Then when you save a record that...

What is the datbase and version of the ARS databse (i.e. Oracle8, Oracle9, SQL Server 7, SQL Server 2000, etc.)? What version of ARS are you using? You should be able to go into whatever tool you use to run SQL queries against any database (Query Analyzer for SQL Server or SQL Plus for Oracle)...

Thanks for the help. I'll take a look at the values you mentioned today. I'm a contractor doing work for a client. It is the client's server that is having the problem. There have been 1,273 Crystal related errors in the Event Log since the morning of September 2. I think this problem is a...

I'm a little out of my depth here, since I'm not the main Crystal guy, so remember to treat me like a n00b. Yes, both services are running on the same machine. And the event log entries say nothing more than what I stated above: Cacheserver loses communication with pageserver [event ID 35202]...

I am having a problem occasionally with my Crystal Pageserver process hanging. In my event log, I see: Cacheserver loses communication with pageserver (Event ID 35202) Stopping and restarting the Crystal Pageserver process gets things running again, but I'm trying to figure out what is...

Thanks for the replies, carp! Are you familiar with Remedy's ARS at all? Basically, you build a bunch of GUI forms and add fields to them (just like you can do in MS Access or with JavaBeans, etc.). Then you add workflow behind the forms using a built-in 4GL. Everything you build can be...

It does look like I'm going to need to figure out an option to compute these values without using statistics. Bummer, I know. But can you offer any help? What about the script I allude to in my original post that can be found here: http://www.think-forward.com/sql/countblk8.htm ? I did get...

The actual business objectives of this project are to develop a product that gives ARS administrators a view into their ARS database from ARS itself. The assumption is that they are not DBAs and do not have access (let alone the knowledge) to get to a SQL prompt and start writing queries to...

Dave, I really appreciate all the help you've been so far! Let me give you a little insight into what I'm working on. The software development company for which I work is about to release a product written to do database analysis specific to Remedy's Action Request System (ARS). I don't know...

Woohoo! Thanks, Dave. That did it. I modified your script as follows to allow for dynamic statistics gathering on the specified table. It worked okay in my tests, will it be okay in the long run? Also, as excited as I am by getting this to work, will it only work on systems that have...

Thanks Dave. I'm *almost* getting it to work. I'm logged in as SYS which is not the owner of the tablespace in which the table resides. The table is called T170 (yep, it's a Remedy Action Request System table) and the owner is ARADMIN. I did try entering the table when prompted as both...

Thanks for the reply. I'm having trouble getting my arms around what I'm being asked for myself, but here is what I'm after: Say I have one data table and only one. It has only two columns in it: a record ID, and a name column. It is a list of boys first names (or whatever). When I create...

I inherited a project from someone and have relatively little knowledge of Oracle8 and PL/SQL. So you'll have to treat me like a dummy. What I need to do is calculate the actual space used in several tables. I found a script that appears to be written to do exactly that here...