jb@aablue.UUCP (John B Scalia) (03/28/89)
HELP!! I've encountered a wierd, possible bug in UNIFY's SQL (I'm using
Convergent's version though its really 4.0). The following script sort of
works:
select salesp.*, Customer_ID, Name, Mail_Address1, Mail_Address2,
Mail_City, Mail_State, Mail_Zip, Main_Phone, Alpha_Key, shipping.*
from custs, shipping, salesp
where salesp.Sales_IDNumber >= 0 and
custs.Salesperson = salesp.Sales_IDNumber and
[shipping.Account_Number = '00000' or
shipping.Account_Number = custs.Customer_ID]/
What I mean is that the script above will blow-up when the >= is run, but
it works perfectly with either > or =, just not both. The script also blows-up
if the first where condition is omitted entirely. (What I thought it should
have been in the first place.) The error I get when it blows-up is not
covered real well (read at all) in the manual. The error is as follows:
***
Thu Mar 23 15:50:05 EST 1989
Program: SQL
Calling function: sqlerr
Offending function: SQL error - see notes
Status: 0
Errno: 25
Notes: dosrch: no selection criteria for index key
No flames please, but I really can't see what in the world I'm doing wrong.
Any help to explain this would be appreciated. BTW, I didn't let this stop
me, I just created a script to run both variations and append them into the
same tmp file; therefore, a quick solution is not required.
--
A A Blueprint Co., Inc. - Akron, Ohio +1 216 794-8803 voice
UUCP: {uunet!}aablue!jb Marriage is a wonderful institution, but who
FidoNet: 1:157/697 wants to spend their life in an institution.
EchoNet: US:OH/AKR.0