[nbusers] Re: Big beginner project! Tutorials? Suggestions?

  • From: Edson Richter < >
  • To:
  • Subject: [nbusers] Re: Big beginner project! Tutorials? Suggestions?
  • Date: Tue, 8 Jan 2013 09:43:57 -0200
  • Organization: Simkorp Inform├ítica Ltda

Em 07/01/2013 21:31, DanDanSC escreveu:
My first issue I'm experiencing is this: I'm trying to add a foreign key to 
one of my tables. The table FIELD_PLACEMENTS has column EMPLOYEE_NUMBER. The 
data in this column needs to match EMPLOYEE_NUMBER in table EMPLOYEES. This 
is so while the application is running, the user may select the employee from 
a list. However, when I try to add the foreign key by right clicking foreign 
keys under FIELD_PLACEMENTS and selecting execute command, then running SQL 
statement :

ALTER TABLE FIELD_PLACEMENTS ADD FOREIGN KEY (EMPLOYEE_NUMBER) REFERENCES 
EMPLOYEES

I get an error saying that table FIELD_PLACEMENTS does not exist. What am I 
doing wrong here?

Ok, this is not specifically a NetBeans issue - I'll try to help, but this discussion is far from our main subject.
You probably have the wrong schema selected. You should check your database documentation about Schemas, Catalogs, Databases and so on.

Regards,

Edson


[nbusers] Big beginner project! Tutorials? Suggestions?

DanDanSC 01/07/2013

[nbusers] Re: Big beginner project! Tutorials? Suggestions?

cuatrocuadrado 01/07/2013

[nbusers] Re: Big beginner project! Tutorials? Suggestions?

Edson Richter 01/07/2013

[nbusers] Big beginner project! Tutorials? Suggestions?

DanDanSC 01/07/2013

[nbusers] Re: Big beginner project! Tutorials? Suggestions?

Edson Richter 01/08/2013

[nbusers] Big beginner project! Tutorials? Suggestions?

DanDanSC 01/09/2013

Project Features

About this Project

www was started in November 2009, is owned by jpirek, and has 21 members.
By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20131025.e7cbc9d). © 2013, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
 
 
Close
loading
Please Confirm
Close