Search results for query: *

How do I pass a variable into a consub which contains spaces??? I need to retain its form (like MACHNAM below), not to be broken up. MACHNAM=THIS HAS A SPACE Example: CONCSUB ${FCP_LOGIN} XXCA 'CUSTOM INTERFACES' KRAMER WAIT=10 \ CONCURRENT XXCA XXCLICDLAA "${COMPANY}" "${TWO_TASK}"...

Hi All, I need some ideas.... Back Ground: - I need to add a company logo to AR statement in in Oracle Reports (ARXSGPO.rdf) - We only have the ability to print Text output - Using Develper 6i - Can not import image, can not use Link File boiler plate My only option is to use an image overlay...

Hi, My Issue: I have a data entry form (form1). When user is done entering their data they press an export button. This button opens another form. This new form (form2)has another command button which preforms several steps, creates a report, updates some tables, removes data from backend...

I am having an issue with the word #Deleted being displayed in my text boxes on a form. The form is a data entry form. User enters data on the form which is loaded into an ACCESS table in the same database. When records are all entered by the user a button is pressed which trggers a few...

Hi, My application is freezing up. I am unsure why. I am running the following code. Form frmfrmDataEntry is open, a button to create a file is pressed and Form frmExportWarning is opened. I hit OK button on the frmExportWarning and then a FTP form is to open but it does not appear and the...

Hi, I want to assign a variable to a value retaine in a table. I am unsure how to do this. sUID = "SELECT tblTransferInfo.User FROM tblTransferInfo;" MsgBox "UID: " & sUID I want the value for the Field User to display.

Hi I am executing a statement which calls ftp.exe. I am unsure how to error handle. It works when the proper user name and user id are entered. But if wrong user id or password is entered I have no error handling. How can I capture the output of the attempted ftp? And determine if the...

Is it possible to transfer data from an Access database to a flat file on an ftp site? I have been able to create a file on a lan drive using TransferText Action. But I have yet to be able to figure out how to do the same to a location on the ftp server? Any suggestions?

Hi, Is there a way to audit (create report) sign-on for ADI, OEM, etc...?

How can I prevent a user from leaving a cell blank (empty)? I would like column A to not allow any blank cells. Preventing end user from entering data into a cell if there are any empty cells above it.

How can I prevent a user from leaving a cell blank (empty)? I would like column A to not allow any blank cells. Preventing end user from entering data into a cell if there are any empty cells above it.

Hi, I am trying to limit user access to certain field ranges. I tried ScrollArea but that only works for one area. Is there a way to limt cell access for more then one range? i.e. Only able to access and enter data in, Range 1 = B1 and B2 Range 2 = A6 to C30

How can I autonumber rows? i.e. A6:A(N)

Hi, I am looking for scheduling information for a concurrent request but am unsure what table to query. Example: I want the schedule for a program that is scheduled to run M-F 5 AM.

How can I build a cusor in PL/SQL by passing in thae table name as a variable? ex l_vExtTable Varchar2(2000) := 'XX'||i_vCompanyName||'_GLCONV_ACT_EXT'; cursor conv_data is SELECT Period_name, Set_Of_Books_ID, Segment1 Company, User_Je_Source_Name, Actual_Flag...

Hi, I want to place one fields value into anothers if it is NULL. I am not sure how to do this. Here is my code for the external table creation: CREATE TABLE XXCPA_BANKFIF_EXT ( BANK_NUMBER VARCHAR2(4), BANK_NUM VARCHAR2(5), INSTITUTION_NAME_ENG VARCHAR2(36)...

Hi, I am running FTP on AIX 5.1 and I am running into an issue. I am connecting to a windows ftp site and am grabbing a file. During the transfer something happens because I am only receivung a partial file. The logs show nothing is wrong. The file is for example 20 kb but only 14 kb gets...

I am trying to create a report in devloper. The layout looks good in developer but when I run in the APPS the layout looks terrible. The columns are squished together, the lines are wrapping, etc. Could someone give me an idea how to create the report in developer and have it appear in the...

HI, I need a query that will retun All responsabilities system profile values for profile 'Printer'. Where can I get this info????

Hi, Is there a way I can use the NLS_LANG is a sql statement to translate english to canadian frech?