Re: sql and informix

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

Article #796

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

#796

From: Geoff Wass
Date: Tue, 21 Jul 1998 00:00

37 lines
1637 bytes

En. Zainal,

Apa khabar?

In what way are you doing your SQL command:

1 ) select * from :informix:ptmed where ptname like 'ALI%'

2 ) SQLEXEC( "select * from :informix:ptmed where ptname like 'ALI%'" )

If you are doing it the first way (local SQL), try it the second
(pass-through SQL). This means the BDE will have nothing to do with
executing the command and will pass it straight through to the Informix
server for it to execute.

If you are already doing it with pass-through SQL, then it becomes an
Informix issue. Perhaps you need an index on the field in question.

You should consider getting the free upgrade to 5.6 which can be
downloaded from http://www.inprise.com/VdBASE/


Jumpa lagi!

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!

Report Inprise/Borland bugs!
http://www.inprise.com/devsupport/bugs/bug_reports.html
=============================================================
Triumph is in the first syllable.

Technical Details

Message-ID: <35B429BA.F248BA80@ibm.net>

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

References: <35B3EBA1.35FF@medic.ukm.my>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8cfa117df13ff39
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: sql and informix
Date: 1998/07/21
Message-ID: <35B429BA.F248BA80@ibm.net>
X-Deja-AN: 373414342
Content-Transfer-Encoding: 7bit
References: <35B3EBA1.35FF@medic.ukm.my>
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message