>hi to all experts
>i try to use Oracle Database In VFP 6.0
>i making one Odbc Connection & i success to call Oracle Database.
>then I made one remote view.that remot views through can i able to modify & delete record in Oracle Database but i am not able to Add new record inside oracle database.
>any one face this problem befor.
>Thnaks in advance
>
>Mazahir
Mazahir,
Check with aerror(). ie:
if !tableupdate(0,.f.,'myView')
aerror(arrErr)
for ix=1 to 7
? arrErr[ix]
endfor
endif
Probably you're not supplying a field that's required, or breaking constraints.
Cetin