>>I'm trying to switch the values from two columns. Here's my code:
>>
>>
update Items;
>> SET cDesc = cIntDesc ;
>> , cIntDesc = cDesc
>>
>>This is a VFP database.
>>
>>Shouldn't that work?
>>
>>What is happening is that both columns get the original value that was in cIntDesc.
>
>That's what I'd expect. This is the same as if you'd written:
>
>
>x=y
>y=x
>
>
>The changes have to occur in some order. You'll have to use a variable to hold one value temporarily.
>
>Tamar
I understand. I just had a very strong memory of using code like this before. Maybe it was on a SQL Server database which apparently allows you to do this.