sqldatasource update problem

L

Lenny

Hi.
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:SqlDataSource ID="SqlDataSource3" EnableCaching="false"
runat="server"
ConnectionString="<%$ ConnectionStrings:Oracle_vega %>"
ProviderName="<%$ ConnectionStrings:Oracle_vega.ProviderName %>"
SelectCommand="select fcli_cliente, to_char(fcli_datainizio,'dd/mm/yy')
as fcli_datainizio, to_char(fcli_datafine, 'dd/mm/yy') as fcli_datafine from
ferieclienti where fcli_cliente = :codice"
UpdateCommand="update ferieclienti set fcli_datainizio =
to_date:)FCLI_DATAINIZIO,'dd/mm/yy'), fcli_datafine =
to_date:)FCLI_DATAFINE, 'dd/mm/yy') where fcli_cliente = :FCLI_CLIENTE and
to_date(fcli_datainizio,'dd/mm/yy') = to_date:)FCLI_DATAINIZIO,'dd/mm/yy')"
<SelectParameters>
<asp:ControlParameter Name="codice" ControlID="gridview2"
PropertyName="selectedvalue" />
</SelectParameters>
<UpdateParameters>
<asp:parameter Name="FCLI_CLIENTE" />
<asp:parameter Name="FCLI_DATAINIZIO" Type="string"/>
<asp:parameter Name="FCLI_DATAFINE" Type="string" />
</UpdateParameters>
</asp:SqlDataSource>


thanks
Lenny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,770
Messages
2,569,583
Members
45,073
Latest member
DarinCeden

Latest Threads

Top