Jump to content

phpmania

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Everything posted by phpmania

  1. 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!
  2. 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!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.