SELECT with INDICATOR?
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca <http://www.forensys.ca/> 416 512 6950 _____ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: February 12, 2009 10:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - How to tell if VARBIT column IS NULL I have a VARBIT column containing images. In my form, I want to determine whether the column is NULL or contains an image and adjust my user interface accordingly. However, any attempt to learn whether the VARBIT column is NULL (for instance IFNULL(VarbitCol, 'Y', 'N')) meets with the error "An expression cannot contain a column of type VARBIT (2928)". Does anyone know how I can figure out whether there's any data in that column? -- Larry No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.18/1937 - Release Date: 02/06/09 11:31:00
