using Tsqlite3dataset / query
lazarus / 16-Databases

----------------------------------------------------------------------
baba · 2006-04-27 12:06

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 · 2006-05-01 09:44

maybe you need to put "" around water (if it is a string)