dBLib

[Terence Heaford]

Thought I’d give this plugin a try:

convert tStartDate from short system date to seconds
convert tEndDate from short system date to seconds
      
dbResetQuery
      
dbWhere "category", pItemName

dbWhere "date >=", tStartDate

dbWhere "date <=", tEndDate
      
dbOrderBy “date"

put dbGet(sq(tTableName)) into tTranData

tStartDate and tEndDate are in seconds.

The SQL generated is 

SELECT * FROM ‘my table' WHERE category = :1 AND date <= :3  ORDER BY date

Why is it not including tStartDate?

Can anyone help?

Thanks

Terry