[Acedb-soft] aql error 810, Inconsistent value types

Dave Matthews via acedb%40net.bio.net (by matthews from greengenes.cit.cornell.edu)
Tue Mar 13 21:08:06 EST 2007

What does this error message mean?

// AQL error 810 around: 'l, m, p from s in'
//                              ^
// Inconsistent value types in table column 3
// Value type was 'g' and now the field evaluates to type 'f' in row 19822

What are value types g and f?

This comes from the following aql query, explorable at 
http://grain.jouy.inra.fr/cgi-bin/ace/custom/aqlInterface/graingenes :

select l, m, p
from s in class sequence where exists_tag s->dna_homol,
     l in s->probe->locus,
     m in l->map,
     p in m[2]

I routinely aql out every map position in the database using a different
query, but it gets them all with no errors, so this is strange.

This is using ace4_9t.

- Dave

-   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
David E. Matthews, PhD            USDA-ARS Plant Genome Database Curator
Cornell University                Email: matthews from greengenes.cit.cornell.edu
Department of Plant Breeding                          Phone: +1-607-255-9951 
409 Bradfield Hall                                      Fax: +1-607-255-6683
Ithaca, New York 14853, USA             GrainGenes: http://wheat.pw.usda.gov

More information about the Acedb mailing list

Send comments to us at biosci-help [At] net.bio.net