Lazarus

Programming => Databases => Topic started by: baba on April 27, 2006, 02:06:50 pm

Title: using Tsqlite3dataset / query
Post by: baba 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
Title: RE: using Tsqlite3dataset / query
Post by: Marc on May 01, 2006, 11:44:15 am
maybe you need to put "" around water (if it is a string)
TinyPortal © 2005-2018