DBD::XBase 'not' not working 
Author Message
 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



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. debugger 'X' command not working

2. $a->popup_menu('name',[\@foo]) will not work

3. split on ':', but not '\:'

4. Need help with simple code not working on my ISP's server

5. Can't find module in @INC- usual fix not working

6. Perl on Win95 not working (newbie question) and flip /'s problem

7. this example won't work..why not?

8. s''' not behaving as expected

9. Logical Not : 'not' vs '!'

10. 5.003_95 - 'boot_SOMESYMBOL' not found

11. Protocol scheme 'http' is not supported

12. It's my bug, not Larry's

 

 
Powered by phpBB® Forum Software