Value Given Error - Newbi

[Cor]

Hi Mad,

This is the error

Now im getting an error saying "Foreign Key
Contraint "SiteArcirsUsers" Requires the Child Key Value (1) to exsist in
the Parent Table"

In my opinion that has nothing to do with your datatable however it says
that it needs a Value to exist in the parent table, there are 3 parent
tables in your schema.

Can you change the select from the SiteArcirsUser temporary to

SELECT * FROM ArcirisUsers WHERE ArcirisUsersId = 1 ' a user which exist
and than what happens (and if gives the error if is true that the parent
values do not exist?)

Cor

 

[MadCrazyNewbie]

Cor,

I`ve figured this one out, it was so obvious aswell, i bet you will kick
youself, i sure did:-

I was filling the Child table first then filling my Parent tables, swapped
it round so it filled my parent table first the my child tables, and now its
fine.

Just thought I would let ya know

Ta
Si

 

[Cor Ligthert]

Hi MCN,

I told you I should be blind.

And this is so obvious, oh my, however I think this I never forget

Thanks, kicks yes



Cor