Click here to Skip to main content
15,890,438 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: register accessing from VB6 Pin
Dave Kreskowiak25-Nov-05 4:16
mveDave Kreskowiak25-Nov-05 4:16 
QuestionForce Panel to scroll Pin
spelltwister24-Nov-05 15:44
spelltwister24-Nov-05 15:44 
QuestionCoding web camera Pin
Amr M. K.24-Nov-05 6:43
Amr M. K.24-Nov-05 6:43 
AnswerRe: Coding web camera Pin
Briga24-Nov-05 7:17
Briga24-Nov-05 7:17 
QuestionEnforcing Referrential Integrity in VB.NET Pin
R. A. Abbasi24-Nov-05 4:56
R. A. Abbasi24-Nov-05 4:56 
AnswerRe: Enforcing Referrential Integrity in VB.NET Pin
Steve Pullan24-Nov-05 18:31
Steve Pullan24-Nov-05 18:31 
GeneralRe: Enforcing Referrential Integrity in VB.NET Pin
R. A. Abbasi24-Nov-05 18:37
R. A. Abbasi24-Nov-05 18:37 
GeneralRe: Enforcing Referrential Integrity in VB.NET Pin
Steve Pullan24-Nov-05 18:51
Steve Pullan24-Nov-05 18:51 
I presume this is for an assignment/project? Unfortunately I cannot give you a tutorial on r/i via what I'd consider the best way (i.e. triggers) as it would take too long and I honestly cannot afford to spend the time doing so. Your best bet therefore is to implement the r/i in discrete code in your program.

This definition explains it better than I can. I hope it helps http://databases.about.com/cs/administration/g/refintegrity.htm[^]:

Definition: Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table.

Consider the situation where we have two tables: Employees and Managers. The Employees table has a foreign key attribute entitled ManagedBy which points to the record for that employee’s manager in the Managers table. Referential integrity enforces the following three rules:

1. We may not add a record to the Employees table unless the ManagedBy attribute poi
2. nts to a valid record in the Managers table. If the primary key for a record in the Managers table changes, all corresponding records in the Employees table must be modified using a cascading update.
3. If a record in the Managers table is deleted, all corresponding records in the Employees table must be deleted using a cascading delete.



...Steve
GeneralRe: Enforcing Referrential Integrity in VB.NET Pin
R. A. Abbasi24-Nov-05 20:58
R. A. Abbasi24-Nov-05 20:58 
GeneralRe: Enforcing Referrential Integrity in VB.NET Pin
Steve Pullan24-Nov-05 23:39
Steve Pullan24-Nov-05 23:39 
QuestionMapping drives in vb.net Pin
kongo1024-Nov-05 3:15
kongo1024-Nov-05 3:15 
AnswerRe: Mapping drives in vb.net Pin
Steve Pullan24-Nov-05 15:01
Steve Pullan24-Nov-05 15:01 
GeneralRe: Mapping drives in vb.net Pin
kongo1025-Nov-05 7:01
kongo1025-Nov-05 7:01 
GeneralRe: Mapping drives in vb.net Pin
Steve Pullan25-Nov-05 11:14
Steve Pullan25-Nov-05 11:14 
GeneralRe: Mapping drives in vb.net Pin
kongo1025-Nov-05 14:39
kongo1025-Nov-05 14:39 
QuestionDisplay random image Dice Roll Pin
chrischik24-Nov-05 2:51
chrischik24-Nov-05 2:51 
AnswerRe: Display random image Dice Roll Pin
Steve Pullan24-Nov-05 12:09
Steve Pullan24-Nov-05 12:09 
Questioncalculate z position Pin
nitin_ion24-Nov-05 1:27
nitin_ion24-Nov-05 1:27 
AnswerRe: calculate z position Pin
Dave Kreskowiak24-Nov-05 5:55
mveDave Kreskowiak24-Nov-05 5:55 
AnswerRe: calculate z position Pin
Briga24-Nov-05 7:15
Briga24-Nov-05 7:15 
QuestionSearch text files... Pin
japel24-Nov-05 0:58
japel24-Nov-05 0:58 
AnswerRe: Search text files... Pin
Briga24-Nov-05 7:13
Briga24-Nov-05 7:13 
AnswerRe: Search text files... Pin
Curtis Schlak.24-Nov-05 15:14
Curtis Schlak.24-Nov-05 15:14 
QuestionWinsock GetData Pin
Marc Soleda24-Nov-05 0:48
Marc Soleda24-Nov-05 0:48 
QuestionCrystal Reports Print Preview Pin
Anup Singh J23-Nov-05 23:59
Anup Singh J23-Nov-05 23:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.