two AQL queries

Dave Matthews matthews at GREENGENES.CIT.CORNELL.EDU
Mon Aug 23 20:34:52 EST 1999


I've been trying to get my feet wet with AQL in ace.4_7l.  Running into some
problems.  Don't know if they're bug reports or just needing syntax help.

1. How to specify field positions after the tag.  
2. How to get more than two columns in the result.  Whatever I ask for in
   the select statement, seems like all I get is the first and the last.

On #1:  At the following prompt:

: % aceclient genome.cornell.edu -port 2020
: acedb at genome.cornell.edu>

the following queries give the results indicated:

: select L, L->Variation_External_DB_Keys[0] \
: from L in class Locus \
: where L->Variation_External_DB_Keys

Dandy, correct.

: select L, L->Variation_External_DB_Keys[1] \
: from L in class Locus \
: where L->Variation_External_DB_Keys

// 0 Active Objects

: select L, L->Variation_External_DB_Keys \
: from L in class Locus \
: where L->Variation_External_DB_Keys

// 0 Active Objects


The last case, whether the "[0]" is necessary or not, is just semantic
sugar.  But so far I still don't know how to get the [1], [2] etc. data at
all.

- Dave




More information about the Acedb mailing list