Re: [firebird-support] Re: expression evaluation not supported

2012-08-20 Thread Jupiter Punungwe
Thank you very much Jonathan. I had managed to figure this out about 30 minutes after making the post. I must admit I was misled by the 'expression evaluation not supported.' message devoid of any detail. Apart from this my sojourn with Firebird is progressing well. Regards Jupiter On Sat, Aug

[firebird-support] Re: expression evaluation not supported

2012-08-18 Thread realoldgeek2008
Hello Jupiter; Sorry you are forced to use something as great as Firebird :-). I assume LAST_MODIFIED_ON is a TIMESTAMP field in your table and is being updated via a trigger or some other mechanism as records are modified. Your DATEDIFF syntax is incorrect; try: ... WHERE

Re: [firebird-support] Re: expression evaluation not supported

2012-08-18 Thread Paul Vinkenoog
Jonathan wrote: Sorry you are forced to use something as great as Firebird :-). I assume LAST_MODIFIED_ON is a TIMESTAMP field in your table and is being updated via a trigger or some other mechanism as records are modified. Your DATEDIFF syntax is incorrect; try: ... WHERE