[firebird-support] Select with a timestamp + 24 hours

Hi All, I have a table with a timestamp field. I need to perform a select to return records that are more than 24 hours past the timestamp value. So something like: Select from STAFF where PASSWORD_TIME + 24 hours < Now Can anyone tell me how to do this? Thanks, Paul

[firebird-support] Help with error message (Firebird 3)

Hi All, I am getting an error during an sql insert, done with Firedac within a delphi vcl app. The error is: [FireDAC][Phys][FB]violation of PRIMARY or UNIQUE KEY constraint "INTEG_50" on table "ROSTER" Problematic key value is ("ROSTERID" = 19) The field ROSTERID is the primary