DBD::XBase 'not' not working
Is there some trick to getting 'not' to work in DBD::XBase?
This will work:
my $sth = $dbh->prepare ("select * from test where (ACCNUM < 2 or
((allele1=='A' or allele1=='B') and (allele2='A' or allele2='B')))");
but this will not:
my $sth = $dbh->prepare ("select * from test where not (ACCNUM < 2 or
((allele1=='A' or allele1=='B') and (allele2='A' or allele2='B')))");
I get this for an error:
DBD::XBase::db prepare failed: Relation expected near ` (ACCNUM < 2 or
allele1 == 'A' or allele...' at C:\Projects\Founder\dbi.perl line 32.
Any help would be very ... helpful.
Ray
