🚀 go-pugleaf

Geoff Wass wrote:
> 
> Zainal,
> 
> Does SELECT hire_date FROM EMPLOYEE work?
> 
> Does SQLEXEC( "SELECT EXTRACT( YEAR FROM hire_date) FROM EMPLOYEE" )
> work?
> 
> I am just fishing around for info that might be useful for narrowing
> down the problem.

ok, after a few testing, I found this code work:

to read from informix, I use

open database informix
set database to
select extract(hour from pptime),extract(minute from pptime),ppdate from
:informix:ptdata ;
 where ptid='123456'

and to write to informix, I use

set database to informix
update ptdata set pptime='9:45' where ptid='123456'


I have to switch "set database to infomix and set database to" to make
it work.
Is there any suggestion to make it easy.

thank

----
zag