09 Feb 2005, 10:15
|
Paschal
Joined on 27-10-2004
Posts 84
|
|
If anyone can help on this.
I have a SQL db with four tables with different relationships. My application create a cached dataset from scratch, and at the end of a process (user has to fill different forms), I want to update the db using the SQL adapter update method.
Most of the examples I can find on the web or in the books are for the update of one table. Nobody really demonstrate anything about cascade relationships. So of course, I run into troubles with the different primary keys and identities field.
Because I don't have the luxury of time, I solved the issue for the moment by updating table after table without their relationship. Not good of course, but if you can point me to some good examples, let me know :-)
|
|
|
|
|
|
|
|
