I've a problem with an update from the sqldatasource
the table cannot be modified because it is from a third party sw
table fields are: codice, fcli_inizio, fcli_fine.
keys are codice and fcli_inizio
when I run the update the field fcli_fine (not key) is updated but not the
fcli_inizio.
this is the code.
db is in oracle.
any suggestion on how to make the changes?
<asp:SqlDataSou rce ID="SqlDataSour ce3" EnableCaching=" false"
runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:Oracle_vega %>"
ProviderName="< %$ ConnectionStrin gs:Oracle_vega. ProviderName %>"
SelectCommand=" select fcli_cliente, to_char(fcli_da tainizio,'dd/mm/yy')
as fcli_datainizio , to_char(fcli_da tafine, 'dd/mm/yy') as fcli_datafine from
ferieclienti where fcli_cliente = :codice"
UpdateCommand=" update ferieclienti set fcli_datainizio =
to_date(:FCLI_D ATAINIZIO,'dd/mm/yy'), fcli_datafine =
to_date(:FCLI_D ATAFINE, 'dd/mm/yy') where fcli_cliente = :FCLI_CLIENTE and
to_date(fcli_da tainizio,'dd/mm/yy') = to_date(:FCLI_D ATAINIZIO,'dd/mm/yy')"
><SelectParamete rs>
<asp:ControlPar ameter Name="codice" ControlID="grid view2"
PropertyName="s electedvalue" />
</SelectParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="FCLI_CLIE NTE" />
<asp:Paramete r Name="FCLI_DATA INIZIO" Type="string"/>
<asp:Paramete r Name="FCLI_DATA FINE" Type="string" />
</UpdateParameter s>
</asp:SqlDataSour ce>
thanks
Lenny