Re: [fpc-pascal] sqldb query error on group by with where clause

2007-09-14 Thread Michael Van Canneyt
On Sat, 15 Sep 2007, Bee wrote: > This query... > > select k_province, k_city, k_school, count(file_id), sum(amt_student) from > upload_log where (date(upload_time)='2007-09-14') group by k_province, k_city > having k_province='205' and k_city='205031'; > > raises exception... > > An unhandle

[fpc-pascal] sqldb query error on group by with where clause

2007-09-14 Thread Bee
This query... select k_province, k_city, k_school, count(file_id), sum(amt_student) from upload_log where (date(upload_time)='2007-09-14') group by k_province, k_city having k_province='205' and k_city='205031'; raises exception... An unhandled exception occurred at $0808E144 : EDatabaseErro

Re: [fpc-pascal] Resourcestring questions

2007-09-14 Thread Michael Van Canneyt
On Thu, 13 Sep 2007, Adriaan van Os wrote: > FPCs resourcestring feature is a great way to localize applications, yet I > have the following questions. > > 1. The tutorial at > > gives the following example >