Jan,
Here's one possible solution: Create a temporary view definition that you can invoke at will. The view would contain the key column from your subject table, and one computed column for each real column that looks like this: (IFNULL(ColumnA,0,1)) The next column in the view would be: (IFNULL(ColumnB,0,1)) So your view has the key and a bunch of integer columns defined as above. Then, the final column in the view adds together the values from all of the other computed columns. Then, all you have to do is retrieve this sum where your key matches, and if it is non-zero, prohibit edit. 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
