>Mark,
>
>I am a little confused. I am not receiving an error. The data that is being saved back to the Oracle table is not trimmed and I want it to be. Is there a way that I can do this without having to use SPT to do the update?
>
>Matt
OIC, sorry 'bout that. There is no way to trim it on the VFP side except with SPT.
On the Oracle side, you can create an InsertUpdate trigger, that would trim any data you want:
create or replace trigger ADDRESS_HISTORY_BEFORE_INSUPDT
before insert or update on npdes.ADDRESS_HISTORY for each row
declare
BEGIN
:new.VarCharField1 := rtrim(:old.VarCharField1);
:new.VarCharField2 := rtrim(:old.VarCharField2);
End;
/
Mark McCasland
Midlothian, TX USA