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
