Hi Stuart ---
Try setting the Updateable properties for the view and for the 'nextval' field True, using DBSETPROP(). I am assuming that the sequence value is 'nextval'.
>I need to know how to access an Oracle sequence from Visual Foxpro 5.0
>I have set up a remote view to the sequence within Foxpro, but I can't seem to get the sequence to increment by selecting the value from the remote view. I tried the refresh() procedure, but I get the error message:
>
> No update tables are specified, use the Tables property of the cursor.
>
>Any help would be greatly appreciated.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05