Subject | Re: [IBO] IBO_Query, stalling on row fetch final code |
---|---|
Author | Helen Borrie |
Post date | 2004-08-15T12:45:42Z |
At 11:57 AM 15/08/2004 +0000, you wrote:
//SELECT 1 id FROM PRODUCT
// WHERE (STOCK_ON_HAND < LOW_WATERMARK)
To return a "result" it should be
SELECT 1 FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)
or to return a list of ids where the stocklevel is too low:
SELECT id FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)
Helen
>Hi HelenThis is wrong:
>
>Thanks for the reply and suggestion, the way I was searching through
>the table was silly anyway, why I di it that way I will never know.
>
>Below is the code I used.
//SELECT 1 id FROM PRODUCT
// WHERE (STOCK_ON_HAND < LOW_WATERMARK)
To return a "result" it should be
SELECT 1 FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)
or to return a list of ids where the stocklevel is too low:
SELECT id FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)
Helen