Recent content by smart99

srw.run_product is not valid built in, so ur getting compilation errors.

Insert the date as using sysdate, when using that column again in use to date to convert as date. TAKING AN EXAMPLE TABLE TEST2 WITH column a as varchar column. Eg : insert into test2 values (sysdate); A --------- 23-AUG-04 SQL> select to_date(a,'DD-MON-YY') FROM TEST2 2 / TO_DATE(A...

Use the following FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="concurrent short name" CONCURRENT_PROGRAM_NAME="concurrent name"

Hi there, Try to have one main content canvas with left hand side of the canvas containg buttons and in the top the corporate image. Have stacked canvases that can be show or hidden when the buttons are hit. Hope it helps.

Hi You can do this using command prompt. Step1: Place ur the java objects to a folder say c:\folder1 in your local m/c Step2: Login into CMD prompt Step3: Switch the directory where the java objects reside. Step4: Execute the following commands with appropriate database connect string...

do u print document? where is it stored? if it is stored in the os directory, u can use host commands from the form to invoke cmmond line print commads. google around for the syntax.

Run the report with a parameter list and add a text-parameter 'MAXIMIZE' with value 'YES'.

It is easy to use the raw datatypes for images. Don't use blobs. Blobs can't be controlled in reports. I have used raw datatypes to store images and created employee reports, its depends how you set the property info for the image items on the reports. Try to use a report wizard intially with...

is it a must to store the photos in local dir.. If not you can store the images as Raw files in the database as column and show it on the report.

if u need all the data into a single column then open a cursor,loop it and append all the values with a delimeter to variable and then insert or update the variable value to the column.

Use a cursor to fetch the the records i.e workorder_no in z_invoice table. Using update/ insert whichever is appropriate use the DML statement to update the workorder_no in the location table. Execute the cursors till cursor records exists

I have faced the same problem. But I don't think you can print a BLOB columns in reports(which stores documents like .doc, .pdf files) I would suggest you follow 2 steps 1. fetch blob data into your local directory using any download method you know. 2. Use host command from your forms to...

I am sure the columns are repeating becoz the columns are within a repeating frame in the report. Create a non repeating frame outside the repeating frame and drop the headings in there.It would solve the issue.

Is the data to be printed is stored as blobs? If not why not use Utl_file to print data into files that can be stored in the windows directory Instead of reports. If you just want the data in the fileformats you can use the UTL_file pacakage.

In Forms if the default orderby clause is set with a column, it takes precedence in the ordering the rows show in a datablock. The column must be present in the datablock for you order by its value. Hope its clear. Suppose there is column expdate in a table expenses, you need to select this...