Search results for query: *

I figured it out, what happened was there was an incorrect table relationship, when I added the table to the fieldList, the page dissappeared because the relationship was wrong.

The underlying record source does not contain any data because it is a blank form and the data entered into my textboxes goes into the database, not the reverse--the records from the database which are currently blank are not to show up on the form. What I am doing is dragging fields from the...

Hi I am working in design view, bounding textboxes and then when I switch to form view the whole page in the details pane is gone. Only the header shows,,,,help please....

I managed to add an updated fieldlist to the form from the properties window. Then I can drag and drop the properties over. That makes them appear in the record source.

Well I got that far but I am setting the control source wrong. I am setting it to =tableName!FieldName That doesn't work.

Hi I just started out in design view with a form. I get a #Name? error on my form. What I want to do is have a text box be blank and when someone enters the data into the textbox I want it to be stored in a table. How do I bind the control to a table?

Thanks so very much, The update table sql worked. I made it more complicated than it really was.

The output is:Cannot insert the value NULL into column 'stdID', table 'clarkOnline.dbo.Student'; column does not allow nulls. INSERT fails. The statement has been terminated. (9 row(s) affected) ---------------------------------------------------------- When I write this: select...

I have a table Student with fields stdID,fName,lName,email and username. I have another table studentType with a field degType for degreeType. The username field is blank and I am trying to write in TSQL that the username field be the (degreeType initial + _ + fName + lName). For example for a...

Does anyone have a link for any PLSQL samples that I can run?

Got it working. What it was was in the control panel for ODBC datasources the sql server driver had to be set to windows authentication mode.

Below is my code and I am getting a connection unsuccessful error. I am trying to use a sql server database. I didn't do anything in the control panel odbc datasources. try { String url = "jdbc:odbc:employeeExpense"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbConn...

Using select username from dba_users I get the error message ' table or view does not exist' Does that mean that there are no databases that I am privelaged to?

In MySQL it is show databases; What is the command to view all of the databases available?

How do I write a stored procedure to declare the following variables @Phone and @CustomerID to equal the Customer's table's fields Customer.phone and Customer.customerID?

I have about a hundred text files,each text file contains information about a person.I have to have these in xml.Is it possible to create an xml schema based on the text files and then import all of these text files to xml with element,field names defined from the schema. When I import them now...

In my C# application I have an update method that is not updating the database. private void btnUpdate_Click(object sender, System.EventArgs e){ oleDbDataAdapter1.UpdateCommand.Parameters.Add("@Phone", contactsPhone); oleDbDataAdapter1.UpdateCommand.Parameters.Add("@CustomerID"...

What happened was the table had a foreign key to itself so I deleted it and it worked. Thanks

I am trying to insert values in a table where there is a foreign key to another table. I can't insert data into either of these tables and get the same errror.... INSERT statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'FK_OrgUnit_OrgUnit'. The conflict occurred in database...

I have 2 long script files the first starts with: IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'empExpense') DROP DATABASE [empExpense] GO CREATE DATABASE [empExpense] ON (NAME = N'empExpense_Data', FILENAME = N'C:\Program Files\Microsoft SQL...