Re: QUERY QUESTION

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

COMPSCI610 wrote:
WHAT DO I NEED TO DO WITH THIS QUERY TO GET IT TO TERMINATE ON A NULL
STRING OR 0?

SELECT STORPOGTRASH.[SPOG#], STORPOGTRASH.[POGSTR#]
FROM STORPOGTRASH
WHERE (((STORPOGTRASH.[SPOG#])=[PLEASE ENTER A PLANOGRAM NUMBER]));

Your caps lock key is stuck. Please unstick it.

What do you mean by "terminate"? Stop without returning any records?
Raise an error?
Do you understand what queries do? They assemble a set of records that
satisfy given criteria and return them to the caller. It's not a process
that "terminates" until the set of records is returned to the caller.



--
HTH,
Bob Barrows


.

Relevant Pages

  • Re: Critique ThreadQueue class please
    ... ThreadQueue delete any remaining queued buffers. ... You need to communicate that to the caller. ... when this semaphore was caught it issued a Terminate ...
    (comp.programming.threads)
  • Re: assert in C
    ... library code) does not terminate the program. ... The caller probably ... will, after doing any necessary cleanup, but the library will not. ...
    (comp.lang.c)
  • Re: 01224547862
    ... before speech) claiming to be from Microsoft Windows. ... a strong foreign accent, knew my name and when I asked him how he had ... The caller wanted me to switch on my computer as he claimed it was ... You did well to terminate the call. ...
    (uk.telecom)
  • Re: Threadpool thread termination.
    ... > (endless loop or something like that). ... They're stuck. ... and so conceivably you could use Win32 to terminate a thread ... that you'll run on the thread pool thread does not go into an endless ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: task model
    ... Make sure the task not terminated before calling its entry. ... the task will terminate cleanly. ... completion code need to be executed, however any local objects are properly ... During the rendezvous the caller is ...
    (comp.lang.ada)