🚀 go-pugleaf

Zainal,

I must admit your first example differs from what I would expect from
the online help description of the commands.

I would have expected:

open database informix
set database to INFORMIX
select extract(hour from pptime),extract(minute from pptime),ppdate from

:informix:ptdata ;
 where ptid='123456'

The select statement, therefore, should be allowed as following:

select extract(hour from pptime),extract(minute from pptime),ppdate from
ptdata ;
 where ptid='123456'

This is what you were able to do successfully with your "write" logic.

Have you been able to make progress in improving the performance of your
SQL commands?

--
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.