Post reply

Table won''t hold edited data - BIZARRE!!

  • June 29, 2006 at 5:33 am

    #91566

    This is probably the wierdest thing I've experienced with SQL so far.

    I have a table where when I edit the data in one of the columns, the data disappears before my eyes. as soon as I move off the record the edited cells value reverts back to its original value. EG The cells original value is "Variations" and I change it to "Variations 1" but when I move off the record it reverts back to "Variations". Heres more strange stuff. This does not happen to every record in the table. In fact this problem currently only affects 8 records out of 311. The field being edited is NOT a key field.

    ContractJobTypeID | ContractID | JobType | IsEssentialService | LabourCharge | MaterialsCharge | GLCode

    618666VariationsFalseFalseFalse2150.0000

    618566PrivateFalseFalseFalse2150.0000

    618466InspectionsFalseFalseFalse2150.0000

    618366Council RequestFalseFalseFalse2150.0000

    6180650063 PlumbingFalseFalseFalse0063.0000

    6179650062 ElectricalFalseFalseFalse0062.0000

    6177650061 CarpentryFalseFalseFalse0061.0000

    613162Lump SumFalseTrueTrue0610.4105

    612862UnallocatedFalseFalseFalse0610.0000

    612562BafflesFalseFalseFalse0610.0000

    In the data above, the records that have a ContractID of 65 and 66 are the only ones that suffer this symptom. I can edit the recs with a ContractID of 62 no problem ContractID is a key field but is not the primaty key (ContractJobTypeID is) All fields are mandatory.

    Can anyone possibly shed some light on what might be causing this? This data is used for invoicing purposes and, being the end of the financial year as it is, is needed TOMORROW so that invoices can be generated. This is critical for me so please, anyone! Your help will be held gently, carressed and treated to long warm showers.

    Cheers All

    Mr. Smith

  • June 29, 2006 at 5:44 am

    #646631

    Andrew,

    have you tried updating the record using an update statement?

    Try something like this:

    update

    set JobType = 'Variations 1'

    where ContractJobTypeId = 6186

    I can't be sure I've used the right columns as the data you posted didn't format well.

    Is it possible you have a trigger on the table?

    Karl
    source control for SQL Server

  • June 29, 2006 at 5:50 am

    #646635

    Sorry, I have already tried that via QA. I forgot to mention it even though I had meant to. Sorry to waste your time by leaving that little tidbit out.

    Mr. Smith

  • June 29, 2006 at 5:56 am

    #646636

    Hey SQLZ.

    You got it. I did have a trigger on it and the OSOB is failing. I can live with it turned off until the invoices are run and worry about fixing it later.

    You are gem!!!

    Mr. Smith

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply