Jan,
Again, there might be a better way, but here is an illustration of my
suggestion. Run this against any database.
CREATE TEMPORARY TABLE testtable +
(keycol INTEGER,+
textcol TEXT (8),+
intcol INTEGER,+
dtcol DATETIME,+
realcol REAL)
INSERT INTO testtable (keycol) VALUES (1)
INSERT INTO testtable (keycol,textcol) VALUES (2,'testtext')
INSERT INTO testtable (keycol,textcol,intcol) VALUES (3,'testtext',8898)
INSERT INTO testtable (keycol,textcol,intcol,dtcol) VALUES +
(4,'testtext',8898,'04/07/2009 12:43:56')
INSERT INTO testtable (keycol,textcol,intcol,dtcol,realcol) VALUES +
(5,'testtext',8898,'04/07/2009 12:43:56',88.4456)
CREATE TEMPORARY VIEW testview (keycol,myc01,myc02,myc03,myc04) AS +
SELECT keycol,+
(IFNULL(textcol,0,1)),+
(IFNULL(intcol,0,1)),+
(IFNULL(dtcol,0,1)),+
(IFNULL(realcol,0,1)) +
FROM testtable
CREATE TEMPORARY VIEW testview2 (keycol,mytotc) AS +
SELECT keycol,+
(myc01 + myc02 + myc03 + myc04) +
FROM testview
RETURN
Now observe the data in testview2. Only the first row has a zero in the
computed column and would therefore be editable in your scenario.
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen
Sent: Tuesday, April 07, 2009 1:58 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Row Check
Group,
Any one got a shortcut for checking if there is data in columns in a row?
While I can do this easily for one column I need to see if there is any
data in like 40 columns in a row. If any of these columns has data
then I need to disable the EDIT function.
Jan
