Did you redefine the VFP remote view of the revised Oracle table?
>Help!
>
>I can't figure this one out.
>I added new columns to an oracle table and VFP form.
>All fields have the same code...
>
>Always there is the following code in the refresh method:
>
>This.DisplayValue = RTRIM(Modacad.moc009)
>with the change of the last column...
>
>All fields:moc009-moc029 work fine..
>
>When the form loads it gets to the refresh on moc030
>The first new field and gives the error:
>
>Error : 1806
>Message : SQL: Column 'MOC031' is not found.
>Message(1) : This.DisplayValue = RTRIM(Modacad.moc031)
>Procedure #1 : ON...
>Procedure #2 : PROCEDURE WMODACAD.MOC031.REFRESH D:\QUESTPDM.ORA\SCREEN\MODACAD.SCT
>Procedure #3 : PROCEDURE WMODACAD.ACTIVATE D:\QUESTPDM.ORA\SCREEN\MODACAD.SCT
>Procedure #4 : PROCEDURE DOFORM FUNCGLOB.FXP
>Procedure #5 : PROCEDURE MODULEPRELOAD FUNCMOD.FXP
>Line # : 1
>Program :
>Database : MODABROW
>Record # : 5
>Mainkey : 21*5*1999*521464
>
>I can't figure this out...
>
>If I take the fields away it works fine.
>I set the debugger on and confirm that the table has the fiels.
>Which is null..But it's there...
>
>
>Any ideas???
Mark McCasland
Midlothian, TX USA