phpmania
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by phpmania
-
-
was wondering if anyone could help me with running php files on wamp server. i seem to have everything set up but cant run the php files from the local host, do i have to put the files in a certain folder in the c: drive?
thanks!
MS SQL Server Error
in Microsoft SQL - MSSQL
Posted
Hi
"Msg 1769, Level 16, State 1, Line 25
Foreign key 'AsstNo' references invalid column 'AsstNo' in referencing table 'ExpenseItem'."
i'm getting this error as i try to execute a bunch of tables into ms sql server. Here are the tables if anyone would be so kind as to have a look;
create table ExpenseItem (
EINo integer,
ExpDesc varchar(255) not null,
ExpenseDate datetime default getdate(),
ExpAmt money default (0) not null,
ExpApprAmt money default (0),
ERNo integer not null,
ECNo integer not null,
AssetNo integer not null,
PRIMARY KEY (EINo),
FOREIGN KEY (ERNo) References ExpenseReport,
FOREIGN KEY (ECNo) References ExpCat,
FOREIGN KEY (AsstNo) References Asset);
create table Asset (
AssetNo integer,
AssetDesc varchar(255) not null,
PRIMARY KEY (AssetNo));
There are other tables but these seem to be the ones with the errors. Hope someone can give me some indication as to whats wrong. Cheers!