executequery lost date？

5 views

Skip to first unread message

韩冰

unread,

Apr 6, 2012, 4:43:07 AM4/6/12

to pldat...@googlegroups.com

i use PLSqliteDatabase for sqlite3 in xcode.

my is:

select A.PL_ID,A.PL_CYCLE,A.PL_EXE_DATE FROM PLAN A ,PLAN_RECORD B where B.P_ID = A.PL_PR_ID and ((A.PL_CYCLE='ONE' and A.PL_EXE_DATE between '2012-03-31' and '2012-05-05') OR A.PL_CYCLE!='ONE')

result has 8 is:

but in the sqlite it has 10 result the results when 'pl_cycle'='one' is lose in xcode, is there any reason?

Reply all

Reply to author

Forward

0 new messages