ACE and SQL-problem

Posted in 1999

Frank Psotka — Fri, 26 Nov 1999 13:29:44 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi all, I have an isql problem while writing an ace-script using INFORMIX SE 7.20. There are two table, lets call them custom: name char(20 ) first char(30) id INTEGER adress: place char(20) zip char(20). Now I want to have all the rows from table custom if name equals the parameter name and just the information from table adress if zip equals another parameter. If the second parameter is empty then I just want to have the information from table custom. Is there a chance to get that information in an ace-script ? Thanx for your help in advance. Frank