home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!munnari.oz.au!bruce.cs.monash.edu.au!monu6!escargot!stan!skt
- From: skt@stan.xx.swin.oz.au (TANG S)
- Newsgroups: comp.databases
- Subject: Help in Rbase!
- Summary: Help in Rbase
- Keywords: Rbase, Database
- Message-ID: <7636@stan.xx.swin.oz.au>
- Date: 14 Dec 92 06:23:56 GMT
- Organization: Comp. Centre, Swinburne University of Tech., Melbourne, Australia
- Lines: 36
-
- I am a new user of Rbase. I have a simple problem here with Rbase. I hope
- someone out there who are familiar with Rbase can help me. I am using Rbase 3.1.
- I want to check if a variable is already in a column of a specified table.
- I have tried several ways, but did not work. The following are some of the
- IF statements I have tried.
-
-
- (1)
- IF itemid EXISTS (SELECT EE# FROM LTrans WHERE EE# = .itemid) THEN
- ...
- ELSE
- ...
- ENDIF
-
-
-
- (2)
- IF itemid IN (SELECT EE# FROM LTrans WHERE EE# = .itemid) THEN
- ...
- ELSE
- ...
- ENDIF
-
-
- (3)
- IF (SELECT EE# FROM LTrans WHERE EE# = .itemid) IS NOT NULL THEN
- ...
- ELSE
- ...
- ENDIF
-
-
- Thanks in advance. Please email to me.
-
-
-
-