How to pass Informix database name as parameter in 4JS programmes

HiI am facing some problems with 4JS programmes. I am working on a project, for that I have used 4JS as front-end and Informix 9.2 as back-end. Currently in my project the name of database is hard-code with DATABASE statement in all 4JS programme i.e.DATABASE bankIn this situation if I am changing t ...

how to pass parameter ton data report when database is mysql

how to pass parameter to datareport when database is mysql. Code normally we write is working for access but not working for mysqlPlease tell me solution ...

Oracle Database VIEW which correspondent to Parameter "SET TIMING ON"

Is there a Database VIEW which correspondent to Parameter "SET TIMING ON" in sqlplus: SQL> set autotrace trace exp statSQL> set timing onSQL> SELECT EMPNO, ENAME FROM scott.emp_big;114688 rows selected.Elapsed: 00:00:00.89Execution Plan Plan hash value: 1946431486 | Id | Operation | Name | ...

report based on Model View (relational) runs much slower than the database view

said: I modeled as a star schema, created a DMR as well for inv, inv_shp_, inv_shp_l (all three invoice tables) and some other tables to write reports and do analysis. I have Cognos BI 8.2When a report is written based on the Model View (star schema) we get four SQL statements that run extremely slo ...

pass parameter to stored procedure through vb.net

hithis is my coding when i run this coding for display the content in textboxes from the database by click event in datagrid. "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied."this error will displaymy sp in sql express isALTER PROCEDUR ...

pass parameter programing

I am working on a Web Application in Asp.net 2.0. I want to pass parameter in crystal report by programming.I write following code on button click but i am getting an Error:"The types of the parameter field and parameter field current values are not compatible."Currently i am passing one n ...

Oracle How to pass parameter to RMAN command?

When i am execute delete.sh file. the following error coming. it expecting to pass parameter YES or NO.How I can pass parameter to RMAN command in shell scripts. [oracle@dbNode1 rman]$ sh delete.shExecuting Command : Backup as copy to file system Recovery Manager: Release 10.2.0.3.0 - Production on ...

jQuery How to pass parameter to the "close" event handler

How to pass parameter to the "close" event handler of the jQuery.ui.dialog? The following codes won't work. If you call rPrompt twice withdifferent index value, the second index value won't be passed to the"close" event handler. I can work around this issue by using a globalvar l ...

database view with just current weekno

I need a database view that will hold only one record with fields current year and current week. The weekno should follow the algoritm:week 1-53 with 1 january starting week 1.Anyone an idea? ...

php script to pass parameter

I have written some script using php. Because those script are not for HTML I would like to know how to pass parameter to my php script.for example,myscrpt -$var=myvar -$var2=myvar2 ...

Oracle Pass Parameter to Control File (Unix Platform)

HiI want to pass parameter from unix script to control file (*.ctl) on Unix PlatForm. Who's know please tell me, or it it cann't do like that how should I do.null ...

Oracle How to pass parameter to cursor (which uses IN string)

I wanted to pass parameter to CURSOR in stored procedure. In the cursor selection WHERE clause I would like to use IN string. When the parameter string has one ID such as E0001 it works fine but when parameter string has multiple IDs such as E0001, E0002, E0003 it does not work. I used single quotes ...

How to pass parameter in Java script

I am using php and mysql; in my code there is one block of javascript.and it works fine when it is single line as given bellow.<a href="#" onclick="return Redirect('http://localhost/readfile.php?file=12.pdf');"> 12.pdf </a>Here I want to pass parameter in place of : 1 ...

Database View at client level

Using multiple SQL joins I have created a database view. But I cannot create View at server level.Is there any database tool that allows me to create the view at client level?For example:View: Select A.*, B.* From A Inner Join B on A.ID = B.IDThen I can execute a query like: Select * From View Where ...

Database view only, how can it work??

How does everybody use the database view (only) with out the ability to enter requirements in between existing requirements. For example if I create requirements 1,2,3,4,5 and then realize I need a requirements between 3 and 4, RequisitePro does not allow it to be placed in between the requirements. ...

How to print detailed text of requirement from Attribute Matrix or database view

We only use the database view in Req Pro (we don't use MS Word at all). We print reports with multiple requirements using SODA. What I can't do is easily print the text of a single requirement I selected. When I follow instructions under Help, all it prints is the name of the requirement. I'd like t ...

pass parameter by use include()

Why I'm pass parameter by use include() function not work?It's have error "file not found". In manual of php write work.Example :include ("http://someserver/file.php?varone=1&vartwo=2"); ...

pass parameter from JavaScript to PHP

How do you can pass parameter from JavaScript to PHP by not use switch case?I'm coding ( Layer4.innerHTML= "<?php $bJobStatus=" + nType + ";include('fListCID.php');?>" ) It's not work.Sample:<SCRIPT LANGUAGE ="JavaScript">function ListCID( nType ){switch (nT ...

Pass parameter in function

I am new in C.Please tell me how to pass parameter in Function. ...

How to pass parameter in Crystal report 9

i want to know that how to pass parameter in crystal report in asp.net using vb.net 2003i want to pass parameter through drop down list controlplz help me out ...

can we pass parameter to trigger?

Hican we pass parameter to trigger???if yes please give me an example... ...

How to Pass Parameter PLACEHOLDER through URL?

Any help would be greatly appreciated!!I understand that by using ? and &, we can pass parameter VALUES through URL. However, in my case, THE PARAMETER PLACEHOLDERS need to be passed instead. For example,<input id="myId" type="text" name="myName">...The " ...

Adding database view

I am slowly moving up the learning curve with Visual C++. I have developed an SDI application but when I first created it I did not chose to incorporate a database view. Can someone tell me the steps needed to add that to my application workspace. ...

Oracle pass parameter to another block

I try to pass parameter to another block. but i have error message.error:PL/SQL: ORA-00904: "C1DATA_REF"."c": invalid identifier.Would you help me?___________________________+++my code+++CREATE OR REPLACE PROCEDURE GETID(a IN TEST.COUNTRY%TYPE,b IN TEST.STATE%TYPE) AS V_ID TEST2.c%TYPE;CURSOR C1_DAT ...

Oracle How to pass parameter from One page to another.

Can anyone help me out how can I pass parameter from one form page to another?Finally I want to hide or show some of the tabs based on the value of this parameter.An example will be very helpful. ...

Oracle how to pass parameter type as table of tablename%rowtype from java?

if can pass parameter type of table of tablename%rowtype pls. explain me. and how to set parameter for execute procedure ...

Oracle TABLE FUNCTION - Using database view - send parameters to the function.

1.- I have a function returning a TABLE OF, and that function recieve 2 parameters of type NUMBER.2.- I'm able to call this function as a table function like this: SELECT * FROM TABLE(my_function(3,4))3.- I want to create a database View, To use this query in diferent places of my app.CREATE OR REPL ...

Oracle Bind a panel to a database view while committing user changes to another DB

Is it possible to bind a panel to a database view while committing user changes to another DB table? For example, forms builder allows a data block to have a view as the query source, while the DML target is another table ...

Pass parameter to subreport

How do i pass parameter into subreport from webform.I tried code supplied in MSDN tutorial for passing parameter into subreport.But it didn't work out.Can anyone help with a working codepiece. ...

Oracle help on a database view

What database view would you use to ascertain whether transactions are being committed? ...

pass parameter from java script to crystal report

want to pass parameter from java script to crystal report, pls refer my following code: c the underlined codeing, it is not working. pls help mme <?php $code = "<html>"; $code .= "\n\t<head>"; $code .= "\n\t<script language='javascript'>"; $code .= ...

pass parameter to running thread

I have a c# program once when one of the button pressed , a parameter can pass to running thread, aspublic void TransfersThread(object data1){.....bRunning = true;for (; bRunning && bResult; ){outData[0] = Convert.ToByte(data1);......}}How can I write a program as to pass parameter to this c ...

Oracle How to Export/Import specific/selected table columns (can database view be

All, I like to export and import some selected columns and rows of a table from one oracle database to another database. For example, I like to export the following SQL's result data to another oracle database. select ename, sal from emp where dno = 100; Can I create a database view based on the abo ...

Oracle how to pass parameter in apps procedure

Can you tell me how to pass parameter in apps procedure.where we pass parameters like retcode and errbuf. ...

Oracle How to pass parameter to cursor for loop having table type?

I am wondering how to pass a parameter into second for loop in the example code below.Please see the bold statements and answer my queries.Thanks a lot .Here is the code .declarel_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ; ---TABLE TYPEV_bom_header_tbl Bom_Bo_Pub.Bom_Head_Rec_Type := Bom_Bo_Pub ...

Oracle How to pass parameter into cursor for loop ?

I want to pass parameter l_bom_header_tbl(i).assembly_item_name into the for statement below How to achieve this?for j in 1 .. l_bom_components_tbl.COUNT LOOP ...

Unable to pass parameter in oracle procedure through unix shell script

I have oracle procedure where in I have to pass the value of procedure parameter through unix script.Follwoing is the sample procedure which i tried to exceute from the unix.Procedure:create or replace procedure OWNER.PRC_TESTING_OWNER(OWNER IN VARCHAR2) AS sql_stmt varchar2(1000) := NULL; v_count n ...

Drill through report - pass parameter value

The query is regarding the Drill- through report. While defining the drill through definition in the source report, I have given as pass data item value and its working fine. But when do we have to use the pass parameter value. Is it that when the source report has the parameter? currently the targe ...

Oracle Pass parameter to a view..

Guys,How can we pass a parameter to a simple view.. Is there any way? Please help, its urgent.Imran Baig ...

Oracle Branch to procedure in database and pass parameter

I have a branch which is a procedure in my database like this127.0.0.1:8080/apex/pnpkg_utility.report_timehr_analysisIn this procedure I need to access a query string which I have stored as an item in the calling page. I cannot pass the string as a parameter as it's quite long and contains punctuati ...

pass parameter to a view??

hello. can you define a view that takes in parameters?somewhat familiar with the &<variable> combo, but not sure how i'd implement creating a view that accepts input parameterssomething like ....CREATE OR REPLACE VIEW view_test (col1, col2, col3, var1 IN varchar2, var2 IN number) AS select ...

Pass Parameter value from Main report to other reports in folder

Phani Pasumarthi said: Hi I have 8 reports with different conditions, but all these reports have same parameters to filter . So we created a Driver Report to select reports from value prompt. I have a javascript to call the report url's based on report choosen from value prompt .. I created static c ...

Oracle Parameter in view

Friends,I want to pass a paramter to a view. Like i want to create view that contanis deptno as an parameter.for example:Create view Emp_Test (p_deptno)asselect * from emp where deptno = p_deptno;this syntes is giving errors. How to write such a view correctly? Please help....its urgent. ...

Verify user-pass Against database

hihalojoy herethis is an include part of my login/page protection scriptit is the part where it all happensif user will VERIFY alrighttried to make it as effective as possiblebecause a page protection script should be as TRANSPARENT as possiblewhen it comes to delay page-viewwhen a user is authorize ...

Oracle Pass Parameters to View

I need to select 3 columns from a table based on the table Primary key column suppose ID so I need to pass Primary key column value. I need to use those 3 column values in all the procedures. So that select statement which is returning the 3 columns based on the input parameter ID. I am going to cre ...

Pass parameter from VB form to Access report

In my vb project, I have allowed the users to view several reports thru access.....The reports in Access are tied to parameter queries. The main form in my vb project has a combo box filled with dates. The date selected is the parameter that I want to pass to the queries and reports in access. I am ...

Oracle Pass parameter to application process from javascript

I am trying to pass a parameter to an application process from javascript and do not know how to do this. What I am trying to accomplish is to create check boxes for deleting multiple records at once. Before these records can be deleted I need to make sure the resource_type_id is not being used. To ...

Oracle How do you pass parameter to a methodaction and get methoditerator back?

I'm using Jdeveloper 10.1.3.5 with BCI'm authenticating using Active Directory - this part is working fine.However I need to be able to search the Active Directory and allow an administrator to select users to add to a custom database table. The database table has the login and name. When someone lo ...

Store Proc can't pass parameter correctly

I'm trying to create a proc (SQL 2000) that takes a single input paramter from a front Cold Fusion app.The parameter should hold a comma delimited string that should look like this:('00012201', 00055445', '33315511', ...(n))so essentially the proc definitiion would look like this:CREATE PROC getInfo ...

MySQL datasource and Cognos 8.3 - database function issue

Csonka Peter said: Does anybody have experience with MySQL datasource and Cognos 8?I am unable to use the MySQL database functions. The simple cast, case.. not workingcast(create_date as date)for test I tried with one table direct from the database, 2column, no join, nothing.RQP-DEF-0177 An error oc ...