Search results for query: *

In sql server, you can select UPPER(tablename.fieldname) from your tablename. But how do I make it work within asp? I keep getting error: Item cannot be found in the collection corresponding to the requested name or ordinal. thx

sorry I am too stressed out to find the thread I sent earlier today. Here is what I am trying to do: 1, per my boss, we want to give our users to ability to do a search based on either firstname, lastname, posnumber, jobtitle, jobgrade, hiredate, and training and posNumber in one table must...

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I have been trying to debug above error to no avail. Please tell me what is causing it. Here is the code...

I am trying to write a query that will return data on a quarterly basis. example, select data from table where data is between 1st quarter and 2nd quarter. data could be queried for any month in any quarter. our company's quarter starts in march. first quarter is mar - may, second quarter is...

I have two separate codes that I need to put in on module in access forms using vb. can anyone tell me how to do this, please? example, if x then do you else do x end if if yes then 10* 20 else 0 end if. I need to put these two if statements in one module. thanks for your help.

To all you great coders, please help!! I am having a date problem. I have three fields: Lov_date, deadline_date, and comleted. completed is boolean = Yes/No. What I am trying to accomplish here is that if lov_date is less than deadline_date then completed should be yes else completed is No. The...

Hi Everyone! This error is strange to me, strange in the sense that I have used it several times without error until now - same syntax! Here it is followed by the error message: run_product(REPORTS,'Emp',Asynchronous,Runtime,Filesystem,null,null); error: too many declarations of RUN_PRODUCT...

Hi Everyone! This error is strange to me, strange in the sense that I have used it several times without error until now - same syntax! Here it is followed by the error message: run_product(REPORTS,'Emp',Asynchronous,Runtime,Filesystem,null,null); error: too many declarations of RUN_PRODUCT...

i am having prolems changing users password as root it tell me it can't write to the /etc/passwd file and a Permission denied message. i need help fast on this . my users are on my neck.

I created a login screen to over-write the oracle default login screen. This works fine. This is where I am having problem: The way the application works now is that once the user logs in, he/she will manually enter his internal emp_id which is numeric and then that emp_id populates his/her...

Why is this not working? DECLARE MouseItem VARCHAR2(80) := :system.mouse_item; BEGIN -- if the mouse is held over a button -- item, show the help text for that -- item in the toolbar text item IF get_item_property(MouseItem, ITEM_TYPE) = 'TEXT ITEM'...

/* If either call_id,request_id or resp_id is empty then make sure that either completed_code is not 'Y', and Incompleted_Code is 'I' */ BEGIN if (:token.r='Y' or :token.i is null)then if (:token.call is null or :token.reqd is null or :token.resp is null or :token_id.c1 is null or...

I have been trying now for the longest to insert records into detail form in a master/detail relationship. I want to be able to: 1, insert and save records in a detail block. 2, I also will like to pull specific records into detail block from master block. I have not been able to accomplish any...

can someone please work me through the process of creating a combox box. I would like to give the user to use the combox as both a search capability. I have created the following code but it is not working. I am getting an error that "no list elements defined for list item. What I did was...

I have created a sysdate to display on my forms. select to_char(sysdate,'Mon/dd/yyyy hh:mm:ss') into :block.datebox; However, what I needed the time to do is blink the seconds. In other words, I want the seconds to update while the screen is open as opposed refreshing the screen to update time...

I created a table with certain fields and some defaults. Example: create table T ( first_name varchar2(25) default 'John'); If I need to remove this default, is there a simpler way of doing it? thanks in advance

Hello good Oracle Gurus! Can someone please tell me step by step or refer me to a source where I can find info on how to clone Oracle Instances. In order words, if I have one database but want to have multiple instances pointing to that database, how do I do it? Thanks in advance! Chidi

I really would like someone to help me on this: First, I installed Oracle 8i on Windows 2000 and then installed forms (formerly knowns developer2000) but when I opened up forms builder and tried to connect using the same username, password and service name used for Oracle 8i, I get an error that...

Can anyone please tell me what Bi-modal joins mean? If necessary, can you please give me an example? Thank you in advance. chidi

It seems like I send a faq everyday but do not see appear on the forum. Let me try again. I need to know if someone can tell me how to write a quarter function. Example, I have 2 tables, t1 and t2. t1 has 3 columns - month_no as char, year_no as char and a key called calendar_id. t2 has two...