Re: anybody out there who uses Visual Foxpro on Progress (V9) data??

From: Anders Altberg (x_pragma_at_telia.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 23:45:47 +0100

Have you set a buffering level 3 or 5 for the view. using CursorSetProp()
With 3, row buffering, the update occurs whenb you move off the row in the
view. With table buffering, 5, you need to call Tableupdate(1,,, ) to send
all updates.
Have you tried a SPT (SQLPassThrough) call
h=CursorgetProp('Connecthandle' ,'myview' )
myvar= '1234'
s= SQLEXEC(h, [UPDATE tablename SET column = ?myvar ] )
If s=1 and REQUERY('myview') makes the view display the updated value , then
the connection and driver are working as expected and the problem would more
likely be in some setting for the view.
-Anders

"Phil" <pgablem1@twcny.rr.com> wrote in message
news:1102441426.353677.133710@z14g2000cwz.googlegroups.com...
> ExtraT wrote:
> > Hi,
> > I hope there is someone that reads this and knows how to update data
> > interactively using Visual Foxpro on data in a Progress (V9)
> database.
> > I can read / report on the data, but updates fail.
> > How did you set up the connection properties and the properties of
> the
> > remote view?
> > In the view designer, update criteria tab, I selected the key field
> > and selected update all fields, selected "send SQL Updates" and
> > left other options at their default values.
> > It is a remote view on a single table.
> > The connection's user id has enough authority to read, write and
> > execute.
> > But if I try to update a field in a record it does not change the
> > record, any changes are lost and the original values remain.
> > I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60
> > 32-BIT).
> > Perhaps it has something to do with the setup of the driver on the
> > server, if so can anybody point me to documentation about how to set
> > it up so updates are allowed?.
>
>
> Please contact me on how to get Foxpro Remote view to work with
> Progress / Vista 6,(a proprietary ERP system authored by Epicor which
> uses Progress as the RDBMS). The connection / remote view is
> established and I can read system tables however I'm getting security
> errors on the Vista tables. Any ideas??
>

Relevant Pages

  • Re: I need help trying to stop dropouts
    ... I too have the buffering problem with heart 106.2, ... have windows xp sp2 and have a cable connection. ... >> usually network congestion or connection to broadcast server lost. ...
    (microsoft.public.windowsmedia.player)
  • Re: please help with windows media player
    ... slow dial up connection or a DSL connection that lots of folks are sharing ... in a popular time of day, buffering is perfectly normal. ... If you're on a dial up connection and cannot afford DSL or broadband, ... > buffers for a long time then the sound breaks up but most of the time I ...
    (microsoft.public.windowsmedia.player)
  • Re: Remote view / cursor oddity
    ... I don't see what buffering has to do with my problem. ... If nothing is open in the data session, and 'track' is a remote view ... USE track IN 0 ALIAS track_curs ... instead of opening a 'track' cursor and inserting into that. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: No buffer space available
    ... Post format, I think it's a logical argument that something is relic in the ... a new copy of the registry should not be buffering ... > "Haim Guivon" wrote in message ... >> connection is broken, and any attempt of redial does not succeed. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Remote view / cursor oddity
    ... If you're using a remote view, there is an implied buffering mode in effect. ... If you move the record pointer in the view, any changes in that record in ... > * since when it completes there is no alias 'track' open. ...
    (microsoft.public.fox.programmer.exchange)