kevinwangsct
6th May 2009, 11:18
I found bsql6.2 from the directory $BSE/bin. Now I am able to do excute some SQL via it.
Do you have any experience with this program?
The problem is, whenever I want to update a field with the value from another field, the same table. It does not work. Could anybody tell me how to write SQL like below to do so?
update tdpur401
set qiap = qidl
where orno = "KT09000001"
Do you have any experience with this program?
The problem is, whenever I want to update a field with the value from another field, the same table. It does not work. Could anybody tell me how to write SQL like below to do so?
update tdpur401
set qiap = qidl
where orno = "KT09000001"