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.
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?
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...
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?
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"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.