Data Source, 1 select, multiple update statements?

BOA_Dev

Active member
Joined
Feb 16, 2007
Messages
32
Programming Experience
1-3
Im using visual web developer

I have multiple formviews on my page. They all display information from the same record, just different columns. So I could use just one data source to populate all of these views. However they all need different update commands. so do I need to make a separate data source for each formview?
 
What I mean is, when I run update on a form that only contains field a and b, it will automatically update c and d to blank space.

I suppose I could modify the update command to only use the new value if its not empty otherwise use the old value. However this would prevent my users from purposely entering blank space.

It just seems like there should be an easy way to do this. Im about to just give up and do everything from code!
 
Back
Top