Ask Your Question
0

Firebird anomaly

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

bbater gravatar image

System: Windows 10, LO 6.3.5.2 (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

Comments

1

Hello,

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
0

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

Stats

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

Seen: 80 times

Last updated: Apr 04