Thread: How convert data in database?
View Single Post
  #2 (permalink)  
Old 06-30-09, 18:37
loquin loquin is offline
Super Moderator
  
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,775
Create a new table, identical to the original table, except with voltage field.

Insert data into the new table, using a subselect in the insert statement. Something along the lines of:

Code:
Insert into NewTable (Field1, Field2, ... Voltage)
Select OldTable.Field1, OldTable.Field2, ... OldTable.RawData * 625/1024 as Voltage
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
Last edited by loquin; 06-30-09 at 18:41.
Reply With Quote