On Thu, 05 Dec 1996 10:28:42 -0800, Joe DeMeyer
Quote:
>Hello,
>Is is possible to use updateable JOINs in VB4? If so, how do I access
>the fields programmatically? For example, how would I set a field
>named SERIALNUM in Table 1 to 12345? Would it cascade to Table 2 which
>has a field named SERIALNUM as well?
Joe,
It all depends on what database you are using as to how you would do
it. Joined queries issued from VB as DAOs or RDOs are always
read-only. The type of update that you are referring to is handled by
the referential integrity rules that you setup in the database if you
are using Access. If you are using SQL Server, you would implement
this capability in the update triggers on the tables.
--
J. Boyd Nolan, PE
Voice:(405) 739-1916 FAX:(405) 739-1095
Boeing Aerospace Operations
Updatable Joins