diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-21 18:12:52 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-21 18:12:52 +0000 |
| commit | 6bff0e985bd6e56bf31184df4d5ca460d5545f34 (patch) | |
| tree | 5276045ed79553a4d83169db7d685706099a9459 /sql | |
| parent | 1626a8a24f559067bd67cfe20304d0c02717d2e0 (diff) | |
Correcting more vendor search errors.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2154 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Company.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index 16dcde77..63714c31 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -41,7 +41,7 @@ BEGIN AND (ec.meta_number = in_meta_number OR in_meta_number IS NULL) AND (c.legal_name like '%' || in_legal_name || '%' - OR legal_name IS NULL) + OR in_legal_name IS NULL) AND ((in_address IS NULL AND in_city IS NULL AND in_state IS NULL AND in_country IS NULL) @@ -79,7 +79,7 @@ BEGIN AND in_business_id IS NULL)) AND (ec.startdate <= coalesce(in_date_to, ec.startdate) - OR (ec.startdate IS NULL) + OR (ec.startdate IS NULL)) AND (ec.enddate >= coalesce(in_date_from, ec.enddate) OR (ec.enddate IS NULL)) LOOP |