Re: Requery('viewname')

Hi,

I incorporate your code into my method and it just display an empty message
box. Clipboard is also empty. Apparently AERROR() did not capture any error
message.

If Requery('viewname') < 0
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


"Mark McCasland" wrote:

> 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
> > >
> > >
> > >
>
>
>
.