Recent

Author Topic: using Tsqlite3dataset / query  (Read 3408 times)

baba

  • Newbie
  • Posts: 3
using Tsqlite3dataset / query
« on: April 27, 2006, 02:06:50 pm »
hi,

how can i use Tsqlite3dataset to execute this query
i understand that we should give the tableName

this query works fine under Sqlite Administrator


sqlquery:

select DISTINCT T_PURE.CAS,PURE_NAME.CAS, PURE_NAME.NAME,T_PURE.NAME from Pure_NAME,T_PURE where Pure_NAME.CAS =T_PURE.cas and T_PURE.NAME= water;

thank's for help

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2496
RE: using Tsqlite3dataset / query
« Reply #1 on: May 01, 2006, 11:44:15 am »
maybe you need to put "" around water (if it is a string)
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker