Home All Groups Group Topic Archive Search About

Problems updating a webform

Author
9 Nov 2006 9:53 AM
Oystein@Norway
Hi! I've got a webform linked to a table containing 15 fields. 11 of these
fields are read only and contains numbers. One of them is unique ID. The 4
other fields contain 2 datetime fields and 2 Signature fields. I try to edit
and update 2 of these fileds. After the update completes the fields shows the
original values and no errormessage appears. The update SQL is automatically
set in the Dataconnection and looks like this:

UPDATE [Emtex_logg] SET [InputSides] = @InputSides, [SimplexPagesPrinted] =
@SimplexPagesPrinted, [DuplexPagesPrinted] = @DuplexPagesPrinted,
[PagesPrinted] = @PagesPrinted, [OutputSides] = @OutputSides, [Colorsides] =
@Colorsides, [NrCopies] = @NrCopies, [LinePrinted] = @LinePrinted,
[PagesToBin] = @PagesToBin, [Submission] = @Submission, [PagesToTray] =
@PagesToTray, [Print_dato] = @Print_dato, [Print_sign] = @Print_sign,
[Konv_dato] = @Konv_dato, [Konv_Sign] = @Konv_Sign WHERE [JobNumber] =
@original_JobNumber AND [InputSides] = @original_InputSides AND
[SimplexPagesPrinted] = @original_SimplexPagesPrinted AND
[DuplexPagesPrinted] = @original_DuplexPagesPrinted AND [PagesPrinted] =
@original_PagesPrinted AND [OutputSides] = @original_OutputSides AND
[Colorsides] = @original_Colorsides AND [NrCopies] = @original_NrCopies AND
[LinePrinted] = @original_LinePrinted AND [PagesToBin] = @original_PagesToBin
AND [Submission] = @original_Submission AND [PagesToTray] =
@original_PagesToTray AND [Print_dato] = @original_Print_dato AND
[Print_sign] = @original_Print_sign AND [Konv_dato] = @original_Konv_dato AND
[Konv_Sign] = @original_Konv_Sign

JobNumber is Unique. The Print_dato, Print_sign, Konv_dato og konv_sign are
the updatable fields.

Can someone help me with this?

AddThis Social Bookmark Button