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
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
Hi Norbert,
Thanks for the answer. Just one little thing in case anyone else needs to do
this. The ; after the "END" in the first case statement should not be there.
But otherwise works perfect.
Cheers,
Paul
Hi All,
I want to give my users the choice of ordering their member list by
FIRST_NAME, SURNAME
or
SURNAME, FIRST_NAME
I managed to get it working using a case statement, but only with one field in
Order By clause. If I put in the second field, it gives me an invalid token
error on the comma.