Search results for query: *

I've built an html page and have no problem launching a new browser window from a submit button using target="NEW". If we send our clients an email with the same html page the submit button will not spawn IE initially. Does anyone know how to launch a browser from a submit button if...

The code above creates the submit button labeled "Approve" and has exactly the same code behind it as when it was in the web page.

I've got a procedure updating some table columns in a database. The code below updates as expected when viewing the page in a web browser. I've been asked to send the page in html to a client using outlook XP but when they click on the "Approve" button the procedure is not being...

I'm trying to clean up some triggers on our database by using "WHEN" statements and am having trouble with those requiring "WHEN INSERTING OR UPDATING". The code below is generating an ORA-00920 Invalid relational operator error. Create or Replace Trigger Validate_EMP_T1 on...

I've got the function returning a value in the view but only when I add the function to the 'WHERE' statement: see below. CREATE OR REPLACE FORCE VIEW MP5DEV.MY_VIEW (ASSET_ID, ASSET_CLASS, LINE_O_BIDNUSS) AS SELECT obj_code, obj_class, get_lob (obj_code) FROM r5objects WHERE obj_obrtype =...

I'm just trying to return LINE_O_BIDNUSS as a column in the view using the return value from the function. The obj_obrtype is just another column in the r5objects table, it has nothing to do with the function. Does this answer your question?

There are 37,179 records if I run the query. If I run the function seperately passing the parameter there are 3,797 records. When adding the function to the view it should populate 3,797 of the 37,179 records with the value but the funtion only seems to return a value on the last record of the...

There is no errors running the create view statement listed above.

I've created a function (get_lob) to return a value which I'm trying to use in a view. My view has about 35,000 records and only the last record has a value returned from the function, the rest are null. Any ideas? See below for the jest of the view script. CREATE OR REPLACE FORCE VIEW...

I have a procedure for oracle 8.1.x where only one parameter is required (p_object). Using TOAD as an SQL editor I have verified the procedure works but when I call the procedure using: exec rigppm_test('0000002') I get the following error: PLS-000306:wrong number or type of arguments in...

duh.. That did the trick. I actually have columns dividing the records, I just didn't want to have my post polluted with code. Thank you...

I'm generating an automatic email usint CDONTS and I'm having trouble. The email has an html header that works wonderfully. My problem is the body, I can't seem to figure out the syntax. The body is this set of looped records. Do Until TestResult.EOF No =...

Thanks Ken, I changed the order of the fields on the SQL statement and that did it!! Gary

I have created a report using the designer in VB6.0. The report was created using 2 tables and utilitzing the ADO(Active Data Object). I have linked the tables and set the fields in question in the "Details" section of the report. The problem in when the report is viewed in the...

I have followed the "Report Variables" sample in the Visual Basic code folder. My report uses ADO to connect to a SQL Server through a DSN connection. If I select one table only, my report works fine passing a SQL Query. In the Designer, the table is called "ado". If I...

I have a memo field that I'd really like to have at the bottom of the page or report footer. The text box could have 1 line or it could have 30 lines of text depending on user input. Are there any options on either making the text box grow towards the top of the page or move the text box...

I've placed a CRViewer on a form, and have a Designer with Field objects on them from tables. I don't understand how to design this report at runtime based on a SQL statement in which the "Where" portion is = to a vb object, i.e. label.caption. I would like to find an example...