I'm porting an application from FB1.5 to 2.x and a query that worked on 1.5
doesn't work on 2.0 or 2.1 (I haven't tried 2.5)
The query is:
SELECT u.Id, u.Name, u.Email FROM Punter u
WHERE u.ALIVE = 1
/* and they haven't blacklisted this issue */
AND u.Id not IN (SELECT bl.UserId
Hi Paul!
I'm porting an application from FB1.5 to 2.x and a query that worked on 1.5
doesn't work on 2.0 or 2.1 (I haven't tried 2.5)
The query is:
SELECT u.Id, u.Name, u.Email FROM Punter u
WHERE u.ALIVE = 1
/* and they haven't blacklisted this issue */
AND u.Id not IN (SELECT
The following script works on FB1.5 but not FB 2.0+
I'm not sure if I can attach a file so I'll also embed the sql script in
the email. I run the script using isql. The script creates the database so
the ods should be correct for each ver of FB.
cheers
Paul
/**Script Start ***/