Recursive Association with compound primary key in SQL database

Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

Oracle 10g database creation errors in windows 7

hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage...

Crystal report viewer

Open REport - No Saved Data This report file does not contain saved data and cannot be viewed. New install of CR 2008 viewing rport over vender database. How do I link data to reports I write? Software/Hardware used: TRAMS and PC - XP

Creating DB of stories from documents for a website

I want to create and maintain a database for a personal library; if it works, I would like to make it available online. I know there are several already available but I’m trying to set up something specific – something for the fanfiction community. (For those not in the know, ‘fanfiction’...

ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g

I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY...

How to save data back to databse from radio button? SQL Server 2005

I am using 4 radio button, what so ever radio button I select, so how data revert back to database, I am doing this in asp.net 3.5 using sql server 2005 Software/Hardware used: Asp.net 3.5

MS Access 2002 Previously updated fields revert to previous values

I have a single user application where I update a status table through VB code using DAO. This particular table has 1 record and 66 fields. As part of the processing, two of these fields are updated after which the table is closed. Later in the processing, I update a different field again for this...

get a anr record from databse by using max (one Field) and orderby (one filed) desc

Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

Database Issues - Trying to prove that something has to be done

Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...

Access/Word Mail Merge Currency lost digits

I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

Adding new entries to a table via a combo box in a form

I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. ...

Database Question.

Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information...

Finding the appropriate settings for copying tables within databases

I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

Logical file

I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just...

Auto-Reply Message for mailbox

Good Morning Exchange God!, Is there a way to have an instant reply message that reads:" Verbiage" When someone sends an email to the mailbox whaterver@something.com, I know we can set it up with the out of the office assistant, but the subject line is appended with Out Of office message. Thanks...

Exchange2000 IM Problem

We have been running Exchange2000 IM for the past few months and it has been working as well as expected with any problems. then all of sudden we started gettting login errors: Exchange Instant Messaging Sign-In Faliure The email address does not match the username and password of the person...

Losing the GUI for Outlook Web Access after login

I am having an issue on Exchange Server 2003. When a user logs on to Outlook Web Access via our secure site, there is no GUI interface. It turns into what looks like a "directory" structure that is completely unuseable. We also host our website on this server, and when we first put the site up, we...

Exchange 2003 STD database keeps filling up

Our Exchange database keeps filling up and shutting us down. We have 2003 Std so I know the limit is 16GB. When we view the mailboxes in the management concole nobody exceeds 50MB, we have 150 users, which should total no more than 7.5GB. > Where is the other space being taken up? > Is the...

Exchange 2K IM Server Question

I have setup a test lab for E2K IM. I installed a separate Win2K server in the test AD Domain; all the latest updates etc. Installed the IM portion of the installation. I ran SP3 on the new server and and reapplied SP3 on the current E2K server that hosts email only. In SM i setup the new virtual...

Oracle 9i Query Time

What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.