Subject Re: date data in SQL statement From Mervyn Bick <invalid@invalid.invalid> Date Sat, 25 Apr 2015 14:03:09 +0200 Newsgroups dbase.getting-started On Sat, 25 Apr 2015 05:34:12 +0200, Pieter van Heerden <psvh@mweb.co.za>   wrote: > Oops, sorry, the root cause of my problem seem to be contained in the   > sql statement: > qp.sql = "select cropid, Growday, Growday growday_tab, week, et0, ke, kc   > kc_tab, kcb kcb_tab, kcmax, etc etc_tab, etc etc_cum_tab, growstage   > stage, rain, cropcover, growday groupday, rdate from irricrop3 where   > cropid = :cropid" > > When I replaced all the column names and replaced the whole lot with: > qp.sql = "select * from irricrop3 where cropid = :cropid" > the problem disappeared. > > Any reason why? > Mm, this SQL statement doesn't look anything like the one in the original   message. :-) It looks as if you typed in the SQL statement rather than copying and   pasting but if you are accessing more than one table a JOIN could be   responsible for the extra rows. Mervyn.