[fpc-pascal] Looking for a Firebird book?

[Matt Emson]

Michael Van Canneyt wrote:
> And it is exactly why I can't use MySQL, MSSQL: they don't have sequences or
> generators. I need the ID  BEFORE I insert the record, not after.
>   

YES!! This is also missing from SQL Server... or at least, using a GUID 
is complete overkill. The mechanisms SQL Server has for retrieving the 
last interted identity value are completely unsane too. Yes, they do 
work, but things get tricky in real world situations. I have no idea how 
anyone wrote reliable code to insert a record and retern the IDENTITY 
value prior to SQL Server 2005.

OT: does anyone know of a reliable generator style "atomic" robust multi 
user friendly auto IDENTITY generation mechanism for SQL Server? I'd 
love to be able to define one, but I don't think I have seen one yet 
that *really* works well.


> So: Each his taste :-

Generators and "For select .. into .. suspend"  are the features I 
really miss from Interbase/Firebird.

M