SQLite3的查询语句问题

21212121

在SQLiteStudio中select distinct biz from Articles where date(ArticleCreated) >(select date('now', '-3 day')) ORDER BY biz DESC
这个语句可以得到结果
但是在tc中得不到结果
  var ret1,ret_arr1,err1
ret1 = sqlitesqlarray("rc:weixinzz","select distinct biz from Articles where date(ArticleCreated) >(select date('now', '-3 day')) ORDER BY biz DESC ",ret_arr1)

我使用的TC5.0
求解！

yecanxue

转义字符？ \'  ？

21212121

谢谢楼上，我是这么搞定的。
var ret15,ret_arr15,err15   
    ret15 = sqlitesqlarray("weixinzz","select date('now', '-10 day')",ret_arr15)
    调试输出(ret_arr15)
    var 值2,key1
    数组获取元素(ret_arr15[0],0,值2,key1)
    var ret1,ret_arr1,err1
    ret1 = sqlitesqlarray("weixinzz","select distinct biz from Articles where date(ArticleCreated) >"&值2&" ORDER BY biz DESC ",ret_arr1)