Re: sql and informix

Article View: borland.public.vdbase.data.sql

Article #835

Back to borland.public.vdbase.data.sql Previous Next

#835

From: zainal ag
Date: Sat, 25 Jul 1998 00:00

26 lines
1104 bytes

Geoff Wass wrote:
> 1 ) select * from :informix:ptmed where ptname like 'ALI%'
> 
> 2 ) SQLEXEC( "select * from :informix:ptmed where ptname like 'ALI%'" )

It work now with this code

open database informix
set database to informix
select * from ptmed where ptname like 'ALI%'

but it is very slow or hanging with code

open database informix
select * from :informix:ptmed where ptname like 'ALI%'

but it is fast to do searching with code

select * from :informix:ptmed where mrn='12345'

compare to 

select * from ptmed where mrn='12345'

---
zag

Technical Details

Message-ID: <35B936BE.5E9B@medic.ukm.my>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35B3EBA1.35FF@medic.ukm.my> <35B429BA.F248BA80@ibm.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8cfa117df13ff39
X-Google-Attributes: gidff5a1,public
From: zainal ag <zag@medic.ukm.my>
Subject: Re: sql and informix
Date: 1998/07/25
Message-ID: <35B936BE.5E9B@medic.ukm.my>
X-Deja-AN: 374690149
Content-Transfer-Encoding: 7bit
References: <35B3EBA1.35FF@medic.ukm.my> <35B429BA.F248BA80@ibm.net>
Content-Type: text/plain; charset=us-ascii
Organization: HUKM
Mime-Version: 1.0
Reply-To: zag@medic.ukm.my
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message