Date Picker Calendar For Oracle Forms 6i

Before you start, make sure you have the "stndrd.olb" and"calendar.pll" file.


DATE_LOV.GET_DATE
(NVL(:BLOCK.ITEM, SYSDATE),
'BLOCK.ITEM',
200, 100,
'SELECT DATE',
'OK','CANCEL',
TRUE, FALSE, FALSE);


ate_lov.get_date (initial date,
return block.item,
window x position,
window y position,
window title,
ok button label,
cancel button label,
highlight weekend days,
autoconfirm selection,
autoskip after selection);


fmb source : https://drive.google.com/file/d/1p-F1AgR_AWbGLatUA7N-Egbzg2lRb8Rx/view

Compile .fmb in folder

one file

ifcmp60 Module=c:\workspaces\project\forms\section\form.fmb Userid=scott/tiger@db batch=yes module_type=form

in folder

FOR %i IN (.fmb) DO ifcmp60 Userid=scott/tiger@db batch=yes module_type=form module=%i batch=yes module_type=form compile_all=yes window_state=minimize


source :






https://dukez.wordpress.com/2010/11/15/compile-oracle-forms-6i-from-command-line-with-olb/

https://www.scribd.com/document/63561272/Batch-Compile-Script-for-Forms-Reports-Libraries-Menus-and-Also-Converting-Binary-to-Text-and-Back-ID-191529-1

Oracle Form 6i dynamic query and execute in oracle

  dynamic query

 1.

set_block_property('DIVIEW_SALESES', default_where, 'query statement');

 example :

set_block_property('DIVIEW_SALESES', default_where, 'sls_status='||''''||'A'||''''||' and to_char(sls_date,'||''''||'mm/yyyy'||''''||')='||''''||:tool.REF_DATE||'''');

Done!

Oracle Designer 6i: How install SQLLDR on win xp

Oracle Designer 6i: How install SQLLDR on win xp

A few weeks ago, i was looking for some articles that discuss "How to install SQLLDR on windows xp?" but i did not get satisfactory results.

After studying some of the structures that exist within the application Designer 6i, I did a little improvisation.

Oracle Designer 6i: How install SQLLDR on win xp?

1.

Download SQLLDR package by this link below.
http://www.4shared.com/zip/YEkcRoB3/sqlldr.html?

2.

Exact the file and it contains 2 files "des_817" and "des_817.reg"

3.

Copy folder  des_817 onto "C:\des_817"

4.

Run des_817.reg

5.

Set up the network connection by "regedit"
HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE >> HOME2

TNS_ADMIN = "your networking path"

mine

TNS_ADMIN = C:\orades\net80\admin

How to use :

1.

Open command prompt (Run >> cmd)

2.

Type this script :

C:\des_817\bin\sqlldr userid=usr/pass@sid control=ctlfile

:)