0 Replies Latest reply: Jan 13, 2011 11:28 AM by 634166 RSS

    Update a join table with SqlDataSource and dotnet and csharp

    634166
      Hi all

      In a forms 10 application i have a DATABLOCK that has a select with a join with 3 tables. In this datablock i also update one of the tables in that select by setting the DML TARGET to the table's name.

      I want to do the same thing in DOTNET. I want a gridview that gives me the output of the join and when i do an update, it only updates one table.

      I know that i can define the update statements but when i put in the SELECT statement the join query, the update no longer works.

      Did anyone had something like this working?

      thanks

      ricardo