Data Source Config in 2.0

[Tinn Man]

in 1.1 when I configured a dataadapter, I generated the select statement and
the update, insert, and delete statements were created automatically for me.
Now with the Data Source Configuration in 2.0 it seems that I have to write
them individually.

After building the select statement, when, for instance, the Update tab is
selected, it is empty.

Is this the case? Do we have to now manually write (or use query builder)
each of the statements manually?

Thanks in advance,
Tin Man

 

[GaryDean]

Hi Tin,
It's a little different in 2.0. In the wizard, to get update statements
automatically generated you have to make the "Specify columns from a table
or view" choice then hit Advanced and you get a choice to generate the
statements and the optiministic concurrency option.

I think the logic is that if you choose the query option you are probably
going to use multiple tables and it can't generate updates for such a
scenario.