From: Vladimir <asodu@...>
Date: 2003-02-27T17:18:54+09:00
Subject: db error

Hi All !
Anybody can explain me, what's wrong?
In this case,  I use only interbase.so  directly, not DBI,
but when I use dbi have same problems.
You can see in code below
------------------------------------------------------
require 'interbase'

conn=InterBase::connect('elf:c:/dbdata/ibdata/icsdata.gdb','sysdba','dbmaster
') sql = "select HRS_DATE, HRS_TIME, HRS_PIPE3, HRS_PIPE4 from HOURS where
 HRS_DATE between '"+strBegin+"' and '"+strEnd+"' order by HRS_DATE" cursor =
 conn.execute(sql)
------------------------------------------------------
ERROR:
./dailyc.rbx:131: in 'execute': Column does not belong to referenced table
(Interbase::Error) from ./dailyx.rbx:131
--------------------------------------------------------------------
SQL Server : Firebird 1.0.2
table Hours
fields
 HRS_DATE type Date
 HRS_TIME  type Time
 HRS_PIPE3, HRS_PIPE4 type double

I understand that problem with fields has date or time types.
How can I work with fields date and time types, not timestamp.
Some code examples
Thanks for advance
Vladimir