473,624 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to search record in oracle form 6i?

43 New Member
hello
i am new with oracle form 6i,
I want to search record in oracle form6i
i am using this code but i dont know it is not working
what is the reason.
---------------------------------------
select empno,ename,job ,mgr,hiredate,s al,comm,deptno
into:emp.empno, :emp.ename,:emp .job,:emp.mgr,: emp.hiredate,:e mp.sal,:emp.com m,:emp.deptno from emp
where empno=:block4.s earch1;
----------------------------------------

Please Send me the Best answer.

thank u in advance.
Jul 20 '10 #1
1 4757
amitpatel66
2,367 Recognized Expert Top Contributor
Can you please provide more information on what you are exactly looking at? Are you looking for Enter Query and Execute Query to Query data from database table in Oracle forms?
Jul 20 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3065
by: se6b14 | last post by:
Dear all, i would like to know that is it mult-thread processing in Oracle Form (6i) ? Please give me advice. Thanks all. se6b14
2
13345
by: Tommy DN | last post by:
I'm working with Oracle Form Builder and I needed a trigger to check something when I delete a record. I made a trigger on ' KEY-DELREC ' and I've written this code ( it's just a test, the delete statement isn't ready ): ---- DECLARE aantal number(8); BEGIN select count(*)
9
4287
by: David Allison | last post by:
cmdButton to Print 3 copies of record in Form view ? cmdButton will print 1 but I need 3 copies of the one Form record. -- Dave Allison
6
6919
by: San | last post by:
Hey, I need to create a form with several text boxes in which users type in key words, press a command button on the form and it opens a matching record. Thanking you in advance.
8
3857
by: Ragbrai | last post by:
Howdy all, I have a form for entering data (Form A), on which is a cmd button that opens Form B in acdialog mode to allow me to enter/edit records that are being displayed on Form A. After adding/editing a record on Form B (opened in acDialog mode), I want a cmd button on Form B to close Form B and then have Form A automatically take me to the record that was added/edited in Form B (Form A has a subform that I will then enter data into). ...
1
4203
by: 3xxx | last post by:
I start to learn the form now with oracle 9i environment (this URL appear after running menu in Oracle forms builder ==>>> program-> run form) http://fujitsuandrew:8888/forms90/f90servlet?form=C:\c\CustomerDemo.fmx&userid=SYSTEM/PASS@&buffer_records=NO&debug_messages=NO&array=YES&query_only=NO&quiet=NO&RENDER=YES got this error in the pop up IE Forms ORA-12560: TNS protocal adapter error
4
3995
by: Steven | last post by:
Hi, Would need some thought about using a button of the existing form to search record before deleting it. Any quick help is very appreciated. Steve
1
7260
by: Indsack | last post by:
Hi all, I want to prepare a Oracle form which should call oracle report and pass parameters in the form to report. Give hint or any keyword to prepare this report.
2
10450
by: Tom Clavel | last post by:
Scratching my head. I am using the filter property on a combo box .AfterUpdate event to get to a single client record. This is causing a some strange behavior: As I enter a subform, I get a no current record error. This is strange to me because: I can see the record contents displayed on the form, and debug.printing them gets me the values. Only the form.recordset is giving me this error. form.recordset .bof and .eof are false. ;...
0
1883
by: MuhammadYassein | last post by:
hi all i am new in Oracle 10g .... and i am new in this forum i hope anyone help me to understand how i can config oracle form how can i use icon , image , Menu , call other forms , create patch file to open main form , use webutil ... can anyone help me .... thx 4 all
0
8238
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8680
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
7164
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6111
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4082
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4176
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2607
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1786
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1485
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.