Re: Requery('viewname')

Modify your code to the following:

lnReturn = REQUERY('view_name')
if lnReturn < 0 and version (2) = 2 && dev environment
local laError[1], lcError, lnI
aerror(laError)
lcError = []
for lnI = 1 to alen(laError)
lcError = transform(laError[lnI]) + CHR(13) + CHR(10)
endfor
messagebox(lcError)
_cliptext = lcError
endif

Since the error info will now be on the clipboard, come back here and post
the error info so we can try to see what is happening.

"Eric Lim" <EricLim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9EFB721-8BD9-4E9A-8F3A-0D8CB01F1BE5@xxxxxxxxxxxxxxxx
> Hi,
>
> Let me update you further on this. With regards to Modal form, it does
> happens but only when you do a REQUERY() in a very fast way. What I have
here
> is master records with three child tables so if I change the record
position
> in the master table the child records with be REQUERY() accordingly.
>
> Thus if I change the master record in a split second the REQUERY() will
> return -1 too although not as obvious as Modeless form.
>
>
> "Mark McCasland" wrote:
>
> > Does the SELECT command used to create the view have any functions like
> > TRIM() for any of the fields being selected? If so, the problem could be
a
> > "base table structure change" type of error. Does AERROR() return any
more
> > information?
> >
> > "Eric Lim" <EricLim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:97595292-0285-497B-8EBA-8CE09F1A5628@xxxxxxxxxxxxxxxx
> > > Hi All,
> > >
> > > Any idea what is the problem if the Requery() returns -1 instead of 0
or
> > 1?
> > > There is no documentation to explain what was the problem if Requery()
> > return
> > > -1
> > >
> > > --
> > > Eric Lim
> >
> >
> >


.

Relevant Pages

  • Re: Requery(viewname)
    ... Clipboard is also empty. ... local laError, lcError, lnI ... >> is master records with three child tables so if I change the record ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Requery(viewname)
    ... > local laError, lcError, lnI ... >> and post the error info so we can try to see what is happening. ... >>> does happens but only when you do a REQUERY() in a very fast way. ... >>> What I have here is master records with three child tables so if I ...
    (microsoft.public.fox.programmer.exchange)
Loading