Hi I need a kind help from you. Will you advise me how to disable Oracle forms runtime window close button? Or how to handle the event when users pressed close button of forms runtime? I am not talking about forms window close button, I am talking about forms runtime window that automatically load when we run a form. Thank you JAISON
how can you find that fmx :/ how you created that ? :/ you not notice in your video that how to create that fmx and i can't find in my computer but i created the user on sql .
Sorry for missing. But i thought, every beginners also know about fmb and fmx format. Whatever, when you compile your fmb file on form builder then it generate fmx file on same name and same folder. I wish, you understand
BTW you reply me comment try to help me to create a enrollment system HAHAHAHA ahm where i should to go to find the modules for my enrollment system or close to that :)
sorry for late, the query "select 'x' from table" returns x for all the rows from the table. Not actual value. Basically, the query is used for rows, columns are exists or not exists in that table. you can use column name instead of this.
then you have to use global variable. in database table, you have to add a column name user. in form, login user will be the global variable. then you have to pass this global variable in that column in the time of insert. you can see my another tutorial about global variable, the link is: th-cam.com/video/Uw-lkIR_0Po/w-d-xo.html
I was following his instructions, but somehow I could not get the value from text items (user_name, password) to compare. Hope you can help me with this issue. Sorry, my English is not good.
Thanks for staying with me. Sorry for late to answer. I didn't get you fully. But i want to say that, please try again in same way. inform me about your success. I hope, you can do it.
Sir Due to EID days I didn't disturb you i ask for your little help just guide me how to migrate to oracle forms you asked from me my educational background i tell you in previous comment i hope you will help me thanks sir i am waiting for your response
Complied with error 'Error 201 at line 12.column 2 identifier 'open_from' must be declared error 0 at line 12, column2 statement ignored............. what to do next? inform me as soon as possible ... thanks ..
when i put the user name and password, it shows to me the form "invaild password or user name ". i dont know why i did the codes step by step, pls inform me
sorry for late.. have you created the users table in database? if done, then no possibility to raise this kind of errors... can u show me the problem by team viewer?
the query "select 'x' from table" returns x for all the rows from the table. Not actual value. Basically, the query is used for rows & columns are exists or not exists in that table. you can use columns name instead of this. it just ensure that, value are exist in the table. for example, sql> select 'x' from users; sql> x x x x x -------------- 5 rows selected that means, the table contains 5 values.
Md Awad Hossain Bhuiyan fmx is the compiled form of fmb file. its the run file, that means when we call a form then we call fmx file for run. and, employee.fmx is not your need. its just en example, you can use your any fmx file for calling. thanks.
Thanks for query. I didn't get you fully. However, "Users" is an existing table of database which contains username and password. In this code, v is my variable. I am selecting minimum 1 data by "x" into v from that 'Users' table. Then it will be matched with text item data. if match, then it goes for next step. Pls inform me if you get me or not.
Please check that : (1)your Field name is exactly "User_name" and "Password" (2) that your datablock name is called "login". (3) dont forget to add colon ":" before your datablock name
writing messages two times only for alert type. when you write once, the message shown in the left-bottom of the screen which is not appeared many times. when you write twice, then the message has been shown like alert. Got it?
v is local variable where i have placed data from table temporarily. "select 'x' from table" returns x for all the rows from the table. Not actual value. Basically, the query is used for rows & columns are exists or not exists in that table. you can use columns name instead of this. it just ensure that, value are exist in the table
Thanks vai.pls r o help full video banan vai. Apnar video golo sob cheye valo lage
Thanks vai.. Onek din video banano hoy na.. Apnader inspiration thakle egiye jawa jay..
Very Helpful
good to see
Hi
I need a kind help from you.
Will you advise me how to disable Oracle forms runtime window close button? Or how to handle the event when users pressed close button of forms runtime?
I am not talking about forms window close button, I am talking about forms runtime window that automatically load when we run a form.
Thank you
JAISON
vi I am so happy, i can get support from your tutorial. I wish we get more .............
Thank you vai.. I will try my best. Because, I/We was sufferer about this kind of problem.
Please stay with me by subscribing my channel..
Pleas provide ur Log IN button Code
yes, actually easy
Hi sir
when ever i try this (trigger raised unhandled exception ORA-01722) i am getting this error.
is there any video for deployment of oracle 10g forms on apache tomcat based website
Helpful..
an improvement
once is connected into the first form
WHEN-WINDOW-ACTIVATED Trigger
IF :GLOBAL.EXIT_FORM = 'Y' THEN
close_form(
END IF;
Sorry for late to answer. Many Thanks for your advice. I will try to remember it.
Please put more videos in forms ji🙏
if i want to display few details of the table after clicking on login how should i do that
Best wishes
Thanks..
Thank You So Much Sir
Bundle of Thanks:)
Qaiser Awan
A lot of Welcome..
need a help plz tell me that how to set background image behind this login form iam w8ing
How can i show you..? you can normally insert an image in background of it.
how can you find that fmx :/ how you created that ? :/ you not notice in your video that how to create that fmx and i can't find in my computer but i created the user on sql .
Sorry for missing. But i thought, every beginners also know about fmb and fmx format.
Whatever, when you compile your fmb file on form builder then it generate fmx file on same name and same folder. I wish, you understand
BTW you reply me comment try to help me to create a enrollment system HAHAHAHA ahm where i should to go to find the modules for my enrollment system or close to that :)
Please tell me sir how to run fmx file
what is the 'X' for in the selection statement ?? thank you
sorry for late,
the query "select 'x' from table" returns x for all the rows from the table. Not actual value. Basically, the query is used for rows, columns are exists or not exists in that table. you can use column name instead of this.
How To make Logout/create user/delete user Form In Oracle
pls ... help me
Thank You ♥️
you see window1 how to change this please ??
if any user update record in any table then how can we find out who did that in oracle form?
then you have to use global variable. in database table, you have to add a column name user. in form, login user will be the global variable. then you have to pass this global variable in that column in the time of insert.
you can see my another tutorial about global variable,
the link is: th-cam.com/video/Uw-lkIR_0Po/w-d-xo.html
getting error when-button-pressed trigger raised unhandled exception ora-01722
please help out
Thank you so much you are aswesome
Your are most welcome..
I was following his instructions, but somehow I could not get the value from text items (user_name, password) to compare. Hope you can help me with this issue. Sorry, my English is not good.
Thanks for staying with me.
Sorry for late to answer. I didn't get you fully. But i want to say that, please try again in same way. inform me about your success. I hope, you can do it.
What is the X in the code
Sir Due to EID days I didn't disturb you i ask for your little help just guide me how to migrate to oracle forms you asked from me my educational background i tell you in previous comment i hope you will help me thanks sir
i am waiting for your response
Complied with error
'Error 201 at line 12.column 2
identifier 'open_from' must be declared
error 0 at line 12, column2
statement ignored.............
what to do next? inform me as soon as possible ... thanks ..
You have done a mistake on spelling..that's not 'open_from'----
that is "Open_form"..I think this is the error. correct it.
when i put the user name and password, it shows to me the form "invaild password or user name ". i dont know why
i did the codes step by step, pls inform me
sorry for late.. have you created the users table in database?
if done, then no possibility to raise this kind of errors...
can u show me the problem by team viewer?
Thank u. Finally I got it
Sir pls explain why to take 'x'..in select
the query "select 'x' from table" returns x for all the rows from the table. Not actual value. Basically, the query is used for rows & columns are exists or not exists in that table. you can use columns name instead of this.
it just ensure that, value are exist in the table. for example,
sql> select 'x' from users;
sql> x
x
x
x
x
--------------
5 rows selected
that means, the table contains 5 values.
what is fmx file .. ? how do i find employee fmx file ?
what was that?
Md Awad Hossain Bhuiyan
fmx is the compiled form of fmb file. its the run file, that means when we call a form then we call fmx file for run.
and, employee.fmx is not your need. its just en example, you can use your any fmx file for calling.
thanks.
fmx is the result file after we make a form in oracle, its more like an .exe file
but where you Declared users(table name) ?
Thanks for query.
I didn't get you fully.
However, "Users" is an existing table of database which contains username and password.
In this code, v is my variable. I am selecting minimum 1 data by "x" into v from that 'Users' table.
Then it will be matched with text item data. if match, then it goes for next step.
Pls inform me if you get me or not.
Hey Mukul, How to close login-form after login?
Thanks for comment. If you use "Call_form" command, the existing login form will be closed..
Error 49 : Bad bind variable 'login.User_name'
Error 49: bad bind variable 'login.Password' 😭😭😭 please help.
Please check that :
(1)your Field name is exactly "User_name" and "Password"
(2) that your datablock name is called "login".
(3) dont forget to add colon ":" before your datablock name
you have pay attention almost every rows we should give ;
I can not log in
Sorry for late..did you use the code in same way?
pls inform me.
Đào Thắm bạn login dc ko, t làm giống trong hướng dẫn mà code cứ vào chạy vào phần exception
and messages two times...
writing messages two times only for alert type. when you write once, the message shown in the left-bottom of the screen which is not appeared many times. when you write twice, then the message has been shown like alert.
Got it?
thanks sir
You are welcome..
Sir can I make a simple project by using hr..schema..tables..
y u put v nd x
v is local variable where i have placed data from table temporarily.
"select 'x' from table" returns x for all the rows from the table. Not
actual value. Basically, the query is used for rows & columns are
exists or not exists in that table. you can use columns name instead of
this.
it just ensure that, value are exist in the table
Error
Identifier 'users' must be declared
YOU HAVE TO CONNECT WITH SQL
What is the X in the code