|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Problems updating a webformfields 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? |
|||||||||||||||||||||||