Forms :: How To Call C++ Code In 6i

Jan 27, 2012

how to call this c++ code by using forms 6i To open and configure the COM port:

HANDLE hCom;
COMMTIMEOUTS lpTo;
COMMCONFIG lpCC;
char str_com[10];
unsigned short no_com = 0;
sprintf( str_com, "\\.\COM%d�", no_com+1);
hCom = CreateFile(str_com,GENERIC_READ|GENERIC_WRITE,0,NULL,

[code]...

To close the port :

CloseHandle(hCom);

To monitor communications events :

SetCommMask(hCom, dwEvtMask );

dwEvtMask is logical or with :

EV_BREAK, EV_CTS, EV_DSR, EV_ERR, EV_RING, EV_RLSD , EV_RXCHAR, EV_RXFLAG, EV_TXEMPTY values

and used WaitCommEvent function

BOOL WaitCommEvent(
HANDLE hFile,
LPDWORD lpEvtMask,
LPOVERLAPPED lpOverlapped
);

View 1 Replies


ADVERTISEMENT

Reports & Discoverer :: Bar Code Reader Will Readout Code

Feb 12, 2009

I have no knowledge about Barcode. The problem is an issue of Loyalty Cards of a Hotel and Restaurant to various customers and then these cards will be presented by the customers time to time in the Hotel as well as Restaurant. The Owner of the Hotel and Restaurant wants to generate separate barcode for each card and when this card will be presented then the bar code reader will readout the code and the system will calculate the amount of discount/rebate. Because if the data entry operator enter the code of the card through key board the it will be a chance of leakage or misuse of that card.

View 8 Replies View Related

SQL & PL/SQL :: Compare SVN Source Code With Production Code In Database

May 30, 2012

I have to compare my SVN source code (packages, views etc) with the production code in the database like views etc (actually we are not sure that what we have in the svn is the final version of production code, we have objects created in the production database, but we don't have latest scripts for that. we have to deploy the svn code in the UNIX box).

So here the comparison is between the OS files and the database objects.

I thought I would get scripts of all the packages, views etc from the production database by using DBMS_METADATA or some utility and save the code in OS files then compare one svn file with OS file manually by using some comparison tools e.g toad provide one comparison tool.

View 5 Replies View Related

SQL & PL/SQL :: Type In Code To Make Few Tables Then Run Code

Feb 13, 2012

I downloaded oracle sql developer, i type my code into a worksheet but if i use the run statement option, it asks me to make a connection. I dont want to make a connection, just test the data locally.However, even if I do try and make a connection, i get ora-12560 error (local connection).

I just want to type up some data to make some table and test to retrieve or manipulate the data. I'll use any program, command line or gui.

View 7 Replies View Related

Forms :: How To Call VB Or NET DLL From PL/SQL

Feb 2, 2010

Is there any way to call a VB or .NET dll from olsql or forms ?

View 14 Replies View Related

Forms :: Generate Bar Code In 6i?

Nov 2, 2011

i want to generate bar code in forms 6i but i don't know the code.

View 3 Replies View Related

Forms :: List Box Code

Apr 1, 2010

View the attached form image.

There are two List boxes namely :list_all (All) and :list_sel(Selected). :list_all show some data. What I want is to insert / delete records from the list_all to list_sel or vice versa using the buttons ( e.g.For one record using > and for all >>). The next step is to call a report to show data from the :list_sel.

I have populated the list_all with using the following query.

"select distinct all_ded,to_char(all_ded_id) from salary_temp order by all_ded"

Forms:6i
Database: Oracle9i

View 1 Replies View Related

Forms :: Call Report From 10g

Feb 1, 2012

I have a form and i want to call report name is " DOCK_RECEIPT". I already create parameter report on this Form name is " REPORT82" and set property this parameter report contain {Name is REPORT82, filename is DOCK_RECEIPT.rdf, execution Mode is Batch, Communication Mode is Synchronous}. I also create a procedure name is F_PRO_PRINT follow:

PROCEDURE F_PRO_PRINT IS
pl_id ParamList;
rep_id REPORT_OBJECT;
V_rep VARCHAR2(100);
rep_status VARCHAR2(20);
rep_job_id varchar2(100);
v_mine_type varchar2(50);
v_palletid NUMBER(10):=0;
[code]...

Now i have button and in trigger when-button-press add this code call procedure above

F_PRO_PRINT;

When i click button call report and appear error.

FRM-41214: Unable to run report

Now, i want to call report from form 10g.

View 1 Replies View Related

Forms :: Call A Block From Another?

Jan 16, 2013

I have a main interface that contains 3 buttons (emp, dept, mgr) I want when I click on the button 'emp' interface opens in the main interface(the buttons must remain in the main interface)

see the picture : [URL]

View 7 Replies View Related

Forms :: Call Report From 11g

Dec 26, 2010

i need call report from forms 11g..Example or Code I have a forms11g and system XP.

View 7 Replies View Related

Forms :: Code To Run Reports From Oracle 11g

Aug 8, 2011

I'm using the following piece of code to run reports from Oracle Forms 11g.

DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);

BEGIN
repid := FIND_REPORT_OBJECT('REP_TEST_R');
v_rep := RUN_REPORT_OBJECT(repid);
END;

On execution, the screen does not respond.Do I need to use WEB.SHOW_DOCUMENT along with RUN_ REPORT_OBJECT?

View 3 Replies View Related

Forms :: Display Code Errors Above 10g

Jul 11, 2011

I have problem follow: i create a forms 10g and run it then errors. Now, i want to display code errors,how do i do?

View 2 Replies View Related

Forms :: Can't See PL/SQL Code While Debugging A Form

Jul 5, 2013

I am using FORMS 6i and while debugging applications (any form), the PL/SQL code inspector panel is always blank, without any PL/SQL code.

I'm using the version 6.0.8.27 of the ifdbg60.EXE file.My OS. is windows XP SP 3 with 4GB of RAM.

I installed first the Oracle Developer v6.0.8.11 and after that, the v6.0.8.27 Patch 18.I also reinstall all Oracle again and nothing.

View 4 Replies View Related

Forms :: Explain Code In KEY-CLRFRM?

Oct 3, 2013

I saw code in KEY-CLRFRM trigger...

Declare
Itm1 varchar2(30) := :system.trigger_item;
Begin
CLEAR_FORM(NO_VALIDATE,FULL_ROLLBACK);
:B1.NEW_FORM := :SYSTEM.CURRENT_FORM; --Here B1 is the Block Name
Go_Item(Itm1);
End;

View 2 Replies View Related

Forms :: How To Call Any Application (EXE) From Menu

Oct 1, 2012

I called an application from Oracle forms using: Client_Host('cmd /c START "" "\localPathmyApplication.exe"'); This works fine on local as well as server.

But when I use the same command to call the application directly from the MENU ITEM, it gives error alert: "WebUtil Error: oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work."

I even tried using DDE.App_Begin(). This gives error: ORA-106561. How can I call any application (.exe) directly from the menu item on the server?

View 3 Replies View Related

Forms :: Call Another Canvas In Same Window?

Feb 22, 2013

I want to call another canvas in same window.using this code /it not work show_view('canvasname');

View 1 Replies View Related

Forms :: Call From Through Menu With Parameter

Feb 3, 2010

how can i call form through menu bar with parameter...

i made a log-in form in which i take user name and i send it to called form in and which forms is called there i create a parameter of that name which i called log-in form...

but when now i reached it on second form there is i use menu.. than how can i send this user name to other forms which i called through menu bar....

I Use this code for calling form through log-in form...

but what can i do for call form with parameter through menu..

DECLARE
ALRT NUMBER;
T_REC NUMBER;

[Code]....

View 5 Replies View Related

Forms :: How To Call Canvas From Menu

Mar 25, 2013

How to call the canvas from the menu module on which the form linked to the menu items.

The canvas lies in the same form where menu is attached.

View 4 Replies View Related

Forms :: Call Reports Using Parameter

Mar 25, 2013

i have one report.the report name is emp and i have 3 user parameters in that report. i want to call report from form. in form i have 3 text fields date ,name ,empno and one button runport..code to call the report from form using this parameter.

View 3 Replies View Related

Forms :: Call Report Using RUN_PRODUCT On 6i And 11g

May 4, 2012

I have a form which calls a report. We are maintaining form's source code in FORMS 6i but the form has to be compiled and executed by FORMS 6i and 11g. We have to maintain source code in FORMS6i as we have clients running multiple version of FORMS. The report calling mechanism uses RUN_PRODUCT which is not supported by FORMS11g. suggest a method (other then RUN_REPORT_OBJECT) to support report calling simultaneously on FORMS6i and 11g.

The reason for not using RUN_REPORT_OBJECT is that we don't want to attach report to form.

View 2 Replies View Related

Forms :: How To Call Canvas From Module A To B

Mar 29, 2013

How to call the canvas from FORM A to FORM B . Form A contains canvas 'can_test'

Form B contains canvas 'can_sub'

I want to call 'can_test' from 'can_sub'

How to achieve this one?

View 1 Replies View Related

Forms :: How To Call Bat File From Oracle

Nov 1, 2007

how to call batch file from Oracle froms 10g

View 18 Replies View Related

Forms :: Call Report From Form?

Jun 5, 2013

i have one report with one parameter name is :description the data of the description is

ALL 1" MD
UBS 2" MD
MNC 23 MSD
LKT 11" WIP
LLP 2 MC

and my question is when i call a report from form it shows the syntax error or command line.if i give the value MNC 23 MSD (or) LLP 2 MC in forms it run good.But if i give UBS 2" MD (or) ALL 1"MD (or) LKT 11" WIP in forms it through REP-159 Syntax error or command line.

View 14 Replies View Related

Forms :: Code Of Creating View In Pre_Form

Nov 25, 2010

Following

create or replace view dept_list as
select 1 state, 1 depth, 'DEPARTMENT' displ_value, null icn, null pk, 'A' sort_value
from dual
union
select -1 state, 2 depth, dname displ_value, null icn, null pk, 'A' sort_value
from dept
union
select -1 state, 3 depth, 'EMPLOYEES' displ_value, null icn, null pk, 'A' sort_value
from dept;

is placed in Pre_Form Trigger it generated error.

Error 103 at line 1, column 1
Encountered the symbol "create" when expected the following.

View 4 Replies View Related

Forms :: Code To Get Label Of Radio Button

Aug 30, 2006

I am working on forms 10g(version 10.1.2.0.2 ) with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on windows 2000 platform. My requirement is to dynamically get the label of the radio button item in a radio group.I am able to get the label of the radio group as shown below

Item :Radio group
Label : Gender

IF m_type = 'RADIO GROUP' THEN
m_label:=Get_Item_Property(m_Item ,label);
END IF;

There two Radio buttons inside this radio group which are
item : Radio button
Label : Male

item :Radio button
Label :female

What is the code to get the label of radio button(i.e) male and female ?

How will I get the count of radio buttons in a radio group at runtime?

View 4 Replies View Related

Forms :: Block Is Populating Values From Code

Jul 7, 2011

I want to search values with F11.for example i will enter some value and i will press F11.it should be display that record. That block is populating values from code.

View 6 Replies View Related

Forms :: Export Source Code Of Object?

Jul 1, 2010

i build a form to get the source code of an object from the database and export the result into a text file but i face a problem I cannot get more than 780 line of code because i have a package with 24080 line and i have to put all this line in the text file

I attached the form

I know that the problem with the size

CM: removed unnecessary colour coding - it doesn't make it easier to read you know.

View 7 Replies View Related

Forms :: Disable Menu - Code Not Working?

Nov 19, 2011

i tried to disable menu but the code didnt work.My

Procedure Pu_Check_Open_Form_Prc(Pv_Menu_Code Varchar2) Is
vn_open_pvg Number(1) := 0;
vm_menu_id MenuItem;
Begin
Begin

[code]...

and my menu in the attached pic.

View 1 Replies View Related

Forms :: Report Call Paper Or Web Layout

Jan 14, 2010

Can we apply both below methods to call paper layout or web layout

1. WEB.SHOW_DOCUMENT()
2. RUN_REPORT_OBJECT()

Or else web layout reports call only from one of them?

View 1 Replies View Related

Forms :: How To Call Procedure From One To Another Object Library

Jan 29, 2013

I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved