Home Forums Programming Connecting Update not working after read database using CASE RE: Update not working after read database using CASE

  • February 6, 2017 at 2:55 am

    #1926809

    John Mitchell-245523 - Monday, February 6, 2017 2:43 AM

    I still don't understand.  What are you trying to do - update the table to turn mm into inches?  I would advise you to store data in consistent units - either imperial or metric throughout.  You mention you have a VB front end - why not have that do the conversion and display the correct units according to the nationality of the user?  Please will you share your UPDATE statement?

    John

    This is exactly what I am trying to achieve. Hence the front end needs to convert the data into the relevant display units from the consistent database units which are mm, I am getting the values in either inches or mm's by use of the select case statement.

    The update is as simple as the below, the update works fine when not using the CASE statement.
       Changes = Table.GetChanges
        If Not IsNothing(Changes) Then Adapter.Update(Changes)
        Table.Clear()
        Adapter.Fill(Table)