Question regarding TSql vs SQL used in Fb

to be honest... i never had need to use any db rather than sql server.

i had developed a little apoplication with three sql statements too simple to be mentioned but an idea from a friend caused me to try firebird.

in fact... i'm stuck! i've tried many docs, most require one take a long time reading through technical documents but for me this is not suitable.

so i put my code here and waiting for a kind expert to translate it for me. i appreciate your kind reply.

i realised that select in code sql is different from select in a stored proce. i could not managed this through stored proc and i need it. application works but in a basic manner: i broke these statement in parts and execute them through one by one steps.

if((SELECT Count(*) FROM [TABLENAME] WHERE [Field1]=N'aaa' AND [Field2]=N'bbb') = 0)
begin
INSERT INTO [TABLENAME]([Field1], [Field2]) VALUES(N'aaa', N'bbb')
select @@IDENTITY as Result
end
else
select -1 as Result

thanks in advance.

Your code seems very MsSQL specific, you would find the same difficulties with every other database, I'd suggest you start reading.

Let me add that Firebird comes with a sample database (employee.fdb) which holds some stored procs also, those are good examples.
You are also using IDENTITY which is not supported in Firebird (and Postgresql and Oracle ....) where you'll find that the same is accomplished with a mix of generators and triggers, so the problem of retrieving the identity field value after an insert is completely different.