campbell@Thalatta.COM (Bill Campbell) (02/23/90)
I have a strange problem with SQL under UNIFY 4.0. A SQL script of the form: select voucher.Number, voucher.Date, voucher.Balance_due, vendor.Vendor_number vendor.Name from voucher, vendor where voucher.Balance_due ^= 0 and vendor.Balance_due ^= 0 and vendor.Vendor_number = voucher.Vendor_number / produces a cartesion join of the voucher and vendor files instead of joining on the Vendor_number columns even though they have an explicit links on these columns! This is part of a production accounting system and has been working for several years and works properly on all my customer systems except one. This same data file has shown some quirky behaviour in SQL queries in the past. I have run REKEY and REPOINT on the data base, but this didn't correct the problem. I have tried different versions of SQL with the same result. I suspect some corruption in the file, but all functions except SQL work properly. The data base is almost 70 Meg and has been reconfigured recently to increase table sizes. Does anyone have any suggestions? ....microsoft--\ Bill Campbell; Celestial Software ...uw-beaver-----!thebes!camco!bill 6641 East Mercer Way ....fluke------/ Mercer Island, Wa 98040 ....hplsla----/ (206) 232-4164 (206) 947-5591 -- ....microsoft--\ Bill Campbell; Celestial Software ...uw-beaver-----!thebes!camco!bill 6641 East Mercer Way ....fluke------/ Mercer Island, Wa 98040 ....hplsla----/ (206) 232-4164