How to create demo version of application using Oracle Form 6i [message #605317] |
Wed, 08 January 2014 12:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/178896.jpg) |
dark_prince
Messages: 121 Registered: June 2013 Location: India
|
Senior Member |
|
|
Hii, I have created an application using Oracle Form 6i and database Oracle 10 XE. Now I want to make this application trial or demo version like my application will only run for limited period for ex for 1 year or 6 month after that application will not start if product key is not entered to make application legal. Before the application is about to expire kinda like 1 month before it should start giving alert that "Please Register application with 16-digit product key." everyday until client register application with product key...
I hope you guys understand my post...
Can anyone tell me how to do this...
|
|
|
|
|
|
|
|
Re: How to create demo version of application using Oracle Form 6i [message #605619 is a reply to message #605475] |
Sun, 12 January 2014 05:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/178896.jpg) |
dark_prince
Messages: 121 Registered: June 2013 Location: India
|
Senior Member |
|
|
Hiii sreee, I tried what you said and i just want to know whatever i did is it accurate or not so please check below code...
CREATE TABLE project_master ( project_code NUMBER(1)
, user_name VARCHAR2(10)
, install_date DATE
, expiry_date DATE
)
/
CREATE TABLE product_master ( product_code NUMBER(1)
, product_key VARCHAR2(16)
, CONSTRAINT product_code_pk PRIMARY KEY (product_code)
, CONSTRAINT product_key_uk UNIQUE (product_key)
)
/
INSERT INTO project_master ( project_code, user_name, install_date, expiry_date)
VALUES (1, 'songoku', to_date(SYSDATE), add_months(TO_DATE(SYSDATE), 12))
/
INSERT INTO product_master ( product_code, product_key)
VALUES (1, 'RAVZWCMP4972P3EX')
/
COMMIT;
I have also uploaded the form of product_master...And here is the code which i used in WHEN-NEW-FORM-TRIGGER of my main form...
DECLARE
key_menu menuitem;
v_user PROJECT_MASTER.user_name%TYPE;
v_install PROJECT_MASTER.install_date%TYPE;
v_expiry PROJECT_MASTER.expiry_date%TYPE;
v_days NUMBER;
v_left NUMBER;
v_check NUMBER;
BEGIN
SELECT user_name, install_date, expiry_date
INTO v_user, v_install, v_expiry
FROM project_master;
v_days := v_expiry - v_install;
v_left := v_days - (to_date(SYSDATE) - to_date(v_install));
IF :GLOBAL.register = 0
THEN
IF v_left BETWEEN 1 AND 15
THEN
--FOR DENABLING REGISTER MENU IN MAIN FORM
key_menu := find_menu_item ('MAIN_MENU.REGISTER');
set_menu_item_property (key_menu, visible, property_true);
set_alert_property ('CAUTION', title, 'Register Alert');
set_alert_property ('CAUTION', alert_message_text, 'Software is Expiring in '||v_left||' Days. Do you want to Register It Now...?');
v_check := show_alert ('CAUTION');
IF v_check = alert_button1
THEN
call_form (:GLOBAL.product_master); --CALLING REGISTER FORM
END IF;
ELSIF v_left > 15
THEN
--FOR DISABLING REGISTER MENU IN MAIN FORM
key_menu := find_menu_item ('MAIN_MENU.REGISTER');
set_menu_item_property (key_menu, visible, property_false);
ELSIF v_left = 0
THEN
:GLOBAL.pro_exit := 0;
END IF;
END IF;
IF :GLOBAL.pro_exit = 0
THEN
exit_form;
END IF;
END;
|
|
|
|
|
Re: How to create demo version of application using Oracle Form 6i [message #605695 is a reply to message #605687] |
Mon, 13 January 2014 12:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You may have a more serious problem with the Forms software. Release 6i is no longer supported so I wouldn't think that your clients can buy licences (and they certainly can't use it for free). Release 10.1.2 has indefinite sustaining support, so I suppose you might be able to persuade Larry to sell you that. But really, you should tell your clients to buy 11.1.2 which has premium support for another two or three years.
|
|
|
|
|
|
|
|