Re: ACE and SQL-problem

Posted in 1999

Charaka . J . Aluthge — Sat, 27 Nov 1999 11:01:23 +0530 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------1C239A38E74002D03E9DC181 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Frank , What is the relation ship between the customer table and the address . i couldn't see any kind of relation between the customer table and the address table . that's why you couldn't get the output you are looking .. Regards Cj Frank Psotka wrote: > 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 --------------1C239A38E74002D03E9DC181 Content-Type: text/x-vcard; charset=us-ascii; name="charaka.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Charaka . J . Aluthge Content-Disposition: attachment; filename="charaka.vcf" begin:vcard n:Aluthge;Charaka . J. Aluthge tel;fax:94 -1 - 437749 tel;work:94 -1 - 541285 / 8 x-mozilla-html:FALSE org:Information Technology<img src="http://cmbco3.cmb-co.LK.DHL.COM/logo2.gif">;DHL KEELLS (PVT) LTD adr:;;No: 130;Glennie Street;Colombo;02;Sri Lanka version:2.1 email;internet:charaka@cmb-co.lk.dhl.com title:Analyst Programmer</font fn:Charaka . J. Aluthge end:vcard --------------1C239A38E74002D03E9DC181--