| forms for more than one user [message #85650] |
Thu, 15 July 2004 18:31  |
kumarvk
Messages: 214
Registered: July 2004
|
Senior Member |
|
|
Hi,
I created a form using data/layout wizard. Before the form is opened I am using the following sql in the when-new-form-instance.
BEGIN
SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE);
SET_WINDOW_PROPERTY('WINDOW1',WINDOW_STATE,MAXIMIZE);
insert into mss_ro_status (RO_NO,RO_OPEN_DATE,CNTA_PERSON,CNTA_PHONE,LIC_NO,STS,ACK,FINISH)
select RO_NO,RO_DTIME RO_OPEN_DATE,CNTA_PERSON,CNTA_PHONE,LIC_NO,STS,'N','R'
FROM MSS_RO_HDR WHERE STS IN('R') AND ROST_CODE <> 'PDI' and ro_no not in
(select ro_no from mss_ro_status);
delete from mss_ro_status where ack='Y';
END;
But the form is not able to open for more than one user. There are more than one user need to open the form but at a time only user can able to open. When first user opened the form until he closed the other user is unable to open. Can anyone help me please. thanks
|
|
|
|
| Re: forms for more than one user [message #85657 is a reply to message #85650] |
Sat, 17 July 2004 08:42  |
raviranja
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
hello.........
u have to create no of clien user which want to open form theny have to make synonym to all tables of your main user in client user.
then u install d2k on client machine . u must keep all forms in server.
reference like it...
u must create d2k run time and change their property give the client user name for ex;- C:ORAWIN95BINifrun60.EXE secuirty acc/acc@erp
and in in start in property give the server address where forms available;;
for eg... i:formproject
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
