table maker query

janety janety at u.washington.edu
Wed May 24 03:18:17 EST 2000


Hi

I am trying to formulate a table maker query but am having problems. 

I have clone objects for which the In_situ tag appears up to three times:
Clone : MB01A01
In_situ 6p21
In_situ 11p13
In_situ 8p24
and I am trying to display the three values in three columns, instead of
on three separate lines in my table. Is this possible without redefining
my model to have three fields In_situ1, In_situ2 and In_situ3? 

I did manage to make a table which displays all three values on one line
BUT which displays them in all six possible orders (and complains many
times about my use of brackets - this might be a bug?). my .def file is
below. However, I have a feeling I am going about it completely the
wrong way. can anybody help?

thanks

Janet 



// Spread sheet definition for the ACeDB software 
// Date: 2000-05-23_20:33:12

// %n (%%n in the graphic)  are parameter to be given on the command
line in tace
// or by default by the Parameters given in this file
// \%n (%n in the graphic) are substituted by the value of column n at
run time
// Line starting with // are ignored, starting with # are comments

Sortcolumn 1

Colonne 1 
Width 12 
Optional 
Visible 
Class 
Class Clone 
>From 1 
 
Colonne 2 
Width 12 
Mandatory 
Visible 
Class 
Class Chrom_Band 
>From 1 
Tag In_situ 
 
Colonne 3 
Width 12 
Optional 
Visible 
Class 
Class Chrom_Band 
>From 1 
Tag In_situ 
Condition (NOT (\%2))
 
Colonne 4 
Width 12 
Optional 
Visible 
Class 
Class Chrom_Band 
>From 1 
Tag In_situ 
Condition ((NOT (\%2)) AND (NOT (\%3)))
 
 

// End of these definitions
---







More information about the Acedb mailing list