> I have two questions for you....
>
> 1.- How can I format a date, for example I have this: dd-mm-yyyy and I want this result yyyymmdd..... there is a function?

If you want to that at the server, for instance when concatenating
strings (including date information) inside a PSQL code module, then
either via a selectable/executable stored procedure or a self-written
UDF. There are also UDF libraries out there which do have such a
function like the rFunc library.

> 2.- How can I get the row number affected in the last Select instruction, like @@ROWCOUNT in SQL Server.

In Firebird 1.5:

There is ROW_COUNT inside a stored procedure or trigger, but that only
makes sense for a DELETE/INSERT/UPDATE statement.


If you want to check whether a record exist, then use in PSQL:

IF (EXISTS(SELECT 1 FROM ....)) THEN
...



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com