Ask Your Question

Firebird anomaly

asked 2020-03-20 03:30:35 +0200

bbater gravatar image

System: Windows 10, LO (x64), Firebird

I'm really not trying to be a nuisance on this forum, but Firebird continues to mystify me in some of its behaviour. I had an existing query using the DATEDIFF function, which ran OK: image description

Whilst experimenting, I created the exact same query to test some other statements, but this instance produces an error:

image description

AFAICS, the queries are identical. Anyone know what's going on here? No wonder I'm finding it confusing!

edit retag flag offensive close merge delete




Have had similar. Can't say the problem. For me, eliminated line returns & re-established then all OK. May be something in the white space.

Ratslinger gravatar imageRatslinger ( 2020-03-20 04:23:17 +0200 )edit

Thanks, Ratslinger, I'll try that.

bbater gravatar imagebbater ( 2020-03-20 16:08:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-04 02:48:33 +0200

bbater gravatar image

Next time I tried the failing query, it worked! So, no answer, just a resolution of the problem.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-20 03:30:35 +0200

Seen: 80 times

Last updated: Apr 04