The following code uses the EditKey and GotoKey methods to move to a particular record on PSQLTable1.
The actual field values are not changed when making the assignments because of the call to EditKey.
with PSQLTable1 do
begin
EditKey;
FieldByName('State').AsString := 'CA';
FieldByName('City').AsString := 'Santa Barbara';
GotoKey;
end;