Dear Friends,

I have a dataenvironment as DE, a connection as cnn, a command as cmdOgrenci and it has a text field "CLASS".

First, how can I update the field CLASS with an sql UPDATE statement on Dataenvironment? I want to change the first character of the field (e.g. 1-A ==> 2-A) while ignore the records begin with "A" and "Y" (ANA, YUVA etc.)

Second what are the adv. and disadv. between ADO and Dataenvironment

Thanks,