error en Select odbc firebird

[yvonne.milne]

Por ejemplo:

// TYPE("employees_calendar.eventstart") = "T" 
lc = SQLCONNECT("Lianja_Southwind")
m_datetime = TTOC(DATETIME(),1)
? SQLEXEC(lc,"select * from employees_calendar where eventstart < stot(?m_datetime)")
SQLDISCONNECT(lc)

// TYPE("orders.orderdate") = "D"
lc = SQLCONNECT("Lianja_Southwind")
m_date = DTOS(DATE())
? SQLEXEC(lc,"select * from orders where orderdate < stod(?m_date)")
SQLDISCONNECT(lc)

[LALMEJA9]

this is ok:

Xfini = DTOS(FINI)
Xffin = DTOS(FFIN)
myselect="SELECT * FROM FACTDIG WHERE FCHFACTURA>= stod(?XFINI) AND FCHFACTURA<= stod(?XFFIN) ORDER BY FACTDIG.FCHFACTURA"

thanks an regards