We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

About relations and foreign constraints

More of a general ADO question but it does have an impact with the Essential Grid. Are there better results when not using a SQL DB foreign constraint versus explicitly defining it within code at runtime? I seem to have nothing but FK or DB Concurrency problems with a simple master-detail grid using a dataset. The underlying SQL 2000 db has a FK constraints defined as well as the master table using a JOIN with detail table (in order to get a total value of all related detail records). I keep fixing/breaking the code, so before I start playing around again, I''d thought I''d ask the pros. Thank you. JV

Loader.
Live Chat Icon For mobile
Up arrow icon