Recent content by sitadba

When doing an export of the problem file, the data/time fields within the middle structure are coming across blank. I have no ideas as to what is causing this. Our version is old. It's SC5.01 with A9901. Any ideas or suggestions would be greatly appreciated.

We are using SC5.01 with A9901, it's old, I know. We are having a problem where we cannot view the task record from within the Change record or from the task queue. If I click on the task from the change record or the task queue, I get an error that says " There is no task record to satisfy...

I have a report which consists of 3 queries. I have 1 repeating frame with 2 other repeating frames inside it, 1 on top of the other. On top and outside of each of the 2 repeating frames is a label/heading from each group. What happens is, if there is not data from either group only the label...

We are using Reports 6i. I have a report for contact information which shows the address in below format. The problem is that if the value of any of the fields is null I do not want a blank line. The fields are all in the R_CONTACTS repeating frame. I set the conditional format for each...

This was EXACTLY what I needed. Thank you Nagornyi!

Thank you very much. I will give this a try. I appreciate your help.

Thank you. Here are our tables. I want it grouped just by airline. AIRLINE_TBL pk_airline varchar2 primary key airline_desc varchar2 USER_TBL pk_userid varchar2 primary key first_name varchar2 last_name varchar2\ title phone email address_1 address_2 address_3 address_4...

I am creating a report that needs 3 sections. For each airline ,I need to show the contacts & their information and then the airports the airline is operating. AA American Airline Contact Information Marie Smith 555-1212 123 Main St John Doe 765-4321 456 South St...

First we are using Service Center V5.01 with A9901. When at the apm.quick form opening a problem ticket, we have a field called 'site'. We open problem tickets for sites and not contacts. There is a link record from the 'site' field to 'site.code' field in the 'siteinfo' file. For each site...

Thank you to dx111ge ! This worked perfect. I appreciate your help. Brgds, Denise

Does anyone know how to remove the carriage return from the evaluating expression in the macro. I have the below expression to create my message. The problem is that the 'GMT' is showing on the next line. $message={"SNS/SMS system test, opening "+tod(), "GMT"} Thank you in advance. Denise

Hello.. We are running Service Center V5.01 on A9901. On our apm.quick form for opening a problem ticket we have a link record from the 'site' field to a 'site' field in a 'siteinfo' file. In that 'site' file there is an array field called 'products' which stores all the product services used...

Dave, This is exactly what I needed. Thanks alot for all your help. Brgds, Denise

Dave, There is no data yet, so we haven't run into a problem. The user interface is TOAD. Next week we will be manually updating the table 1 record at a time and not from an insert statement. I want to be able to add all the fields except pk_loc_id. Then when I save, the pk_loc_id field is...

Dave, Thank you very much. That was a big help. I have 1 more question. The end users will be updating this table via a user interface application and not through an insert statement via sql plus. Do I need a trigger on insert whenever a record is being added to the ops_locations table...