Ok, after looking at this and seeing if there are other examples of POST
not posting what is in the various editors, I can see that this
qryPatientSession is the only one.

I am assuming that the reason things are not being posted is because of
the calculated field (f-str2str() as FieldName). At this point the real
question is: why did it work before?

What is helpful for other calculated field uses is that one can access
the editor values via the Dataset.FieldByName() just fine right up to
the POST, then in the AfterPost one can do an UPDATE to put the
calculated value back into the table.

Chuck Belanger

> Hello:
>
> I have been using D2007 with FB 2.5 with IBO 4.8.7 with a Woll2Woll
> RecordViewPanel which requires TDataset to add patients to the local DB.
> The patient data is encrypted. Everything has been working fine for over
> a year. Now with IBO 5.0.2 (_b52a update) in XE2, the entered data is
> not posted. Below is the salient code and what I am observing:
>
> WITH qryPatientSession DO
> BEGIN
> //decrypting all encrypted patient fields
> SQL.Add('Select f_str2str(Name_First,' + inttoStr(TV.HPW)+') as
> Name_First,');
> SQL.Add('F_Str2Str(Name_Last,' +InttoStr(TV.HPW)+') as Name_Last,');
> SQL.Add('F_Str2Str(Upper_Name_Last,' +InttoStr(TV.HPW)+') as
> Upper_Name_Last,');
> SQL.Add('F_Str2Str(Address1,'+InttoStr(TV.HPW)+') as Address1,');
> SQL.Add('F_Str2Str(Address2,'+InttoStr(TV.HPW)+') as Address2,');
> SQL.Add('F_Str2Str(City,'+InttoStr(TV.HPW)+') as City, ');
> SQL.Add('F_Str2Str(State,'+InttoStr(TV.HPW)+') as State, ');
> SQL.Add('F_Str2Str(Country,'+InttoStr(TV.HPW)+') as Country, ');
> SQL.Add('F_Str2Str(Postal_Code,'+InttoStr(TV.HPW)+') as Postal_Code, ');
> SQL.Add('F_Str2Str(Phone,'+InttoStr(TV.HPW)+') as Phone, ');
> SQL.Add('F_Str2Str(Email,'+InttoStr(TV.HPW)+') as Email, ');
> SQL.Add('F_Str2Str(Cell_Phone,'+InttoStr(TV.HPW)+') as Cell_Phone,');
> SQL.Add('F_Str2Str(Work_Phone,'+InttoStr(TV.HPW)+') as Work_Phone,');
>
> SQL.Add('PT_ID,');
> SQL.Add('PR_ID,');
> SQL.Add('FIRST_VISIT, ');
> SQL.Add('BIRTHDATE, ');
> SQL.Add('GENDER, ');
>