Hi all,

Initially i set my foreign key's field's column properties's Default value or Binding to 0. After while i want back Null values to be saved and i remove 0 from Default value or Binding. However still default value 0 but not Null values saved.

Please advice...

Hi Edhy,

let me give an example:

2 tables there are the purchase order and customer. In the purchase order table, there have customer link into it as a foreign key. I did set referential integrity for this relationship between purchase order and customer.

My problem is when i try to insert new record for purchase order and i didn't choose customer, suppose foreign key customer inside purchase order table is default to NULL. Strataframe framework do prompt me the message like "The insert statement conflicted with the foreign key constraints.........................."



Please advice 

Where did you set the referential integrity: in MS-SQL or in the StrataFrame (SF) Business Objects?

If you created the RI in MS-SQL, then delete it since using StrataFrame you really don't need it unless you will be adding records outside StrataFrame. SF handles the relationship via the Business Object where you can do as many relations as you want and also via code.

Edhy Rijo