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