Re: Requery('viewname')

If I only had a nickel....

<g>

Dan

Mark McCasland wrote:
> duh! Thanks for the "catch"
>
> "Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
> news:O8$6wC4PFHA.2468@xxxxxxxxxxxxxxxxxxxxxxx
>> Slight omission in Mark's code. Inside the FOR loop:
>>
>> lcError = lcError + transform(laError[lnI]) + CHR(13) + CHR(10)
>>
>> Dan
>>
>> Eric Lim wrote:
>>> 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


.

Relevant Pages

  • Tanya svchost.exe
    ... Salam kenal saya mule baru kali ini sign in di google grup, ... Pertanyaan sy sekitar error message svchost.exe setelah sy mulai coba ... browser dan sound akan mati kalau message tsb di eksekusi (hanya ada ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Generic Host Process for Win 32 error
    ... You receive a "Generic Host Process" error message after you start the ... > Dan in Milwaukee, Wisconsin ... >> Are you using Windows XP Home or Professional Edition? ...
    (microsoft.public.windowsxp.newusers)
  • Re: Stupid fast
    ... less safe than they should be and reduce the travel speeds. ... A 135mph on an empty interstate just isn't a problem. ... I semi-regularly see motorcyclists going close ... motorcyclists turning themselves into paste on the dan ryan.... ...
    (rec.autos.driving)
  • Re: dlookup problem
    ... <MS ACCESS MVP> ... > is in SQL Server. ... you'll get an error message from ACCESS: ... >>> Dan D. ...
    (microsoft.public.access.reports)
  • Re: Disk Defragmenter
    ... Dan wrote: ... Error message when you try to open a MMC Console: ... How to fix Disk Defragmenter problems in Windows XP: ...
    (microsoft.public.windowsxp.accessibility)