UPDATE table SET col1 = col2 not working
Posted on 2008-06-18
Hello software engineers,
I'm trying to copy data from one column to another in an Access table using SQL from Delphi and I'm not having any luck.
The following worked in Access: UPDATE PowerUnits SET [TEMP] = Name;
Tried this and got no error, but no data were copied to the TEMP column:
with MyQuery do
SQL.Add('UPDATE PowerUnits SET [TEMP] = Name');
Tried this and the column was still not copied:
DataMod.CommandQuery.CommandText := 'UPDATE PowerUnits SET [TEMP] = Name';
I also tried both of the blocks of code above with no brackets around the TEMP column name. BTW, I know that the TEMP column exists, and the only difference between the two columns is that TEMP has Unicode Compression set to YES and Name does not. They are both CHAR(25).
Help, please. I've been floundering for hours! :)