Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1806 SQL: Column 'MOC031' is not found..But it is
Message
 
 
To
03/08/1999 06:49:20
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00249140
Message ID:
00249165
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform