Below should get really close. A few useful notes:

1. Your stored procedure is using [] for Delimited Identifiers. InterBase uses "", which I believed is the SQL standard - and MSSQL can use too.
2. To return the current date, use the sql keyword current_date. Looks like MSSQL uses CAST(GETDATE() AS DATE) for the current_date.
3. To return a unique number, use generators. gen_id() with a generator gives you a new value.
4. Use declare variable for variables. When used with a SQL statement, add a colon (:) in front of them - instead of an @.
5. Statements end in a semicolon (;).
6. InterBase does not have schema's, so no dbo needed. Just make sure you have been GRANTed the appropriate permissions on the necessary tables.

--
create generator mygenerator;
create trigger "ScaleReadingCheck" for "ScaleReading" after insert as
begin
declare variable thecount integer;
declare variable oid integer;
select count(*) from inserted into :thecount where (
"CellsReset" = 1
or "CellVoltageError" = 1
or "IdError" = 1
or "IdErrorState" = 1
or "NewSystem" = 1
or "ReplacementCard" = 1
or "ReplacementCell" = 1
or "ScaleNotConfigured" = 1
or "ScaleNotLinked" = 1
or "ScaleNotLinked_Occasionally" = 1
or "ScaleTemeratureError" = 1
or "ScaleVoltageError" = 1
or "ScaleWarmup" = 1
)
and inserted.Scale <> (
select Scale
from BaseEmailQueue as b
inner join SIHMSEmail as s
on b.Oid = s.Oid
where cast(b.DateCreated as DATE) = current_date);

if (thecount>0) then
begin
oid = gen_id(mygenerator, 1);
insert into BaseEmailQueue(oid,SendToEmailAddress,EmailClassification,DateCreated, Sent)
select :oid, Customer.Email, 0, current_date, 0
from Scale, Customer, Company, inserted
where
inserted.Scale = scale.Oid
and Company.Oid = scale.Company
and Customer.oid = scale.Customer;

insert into SIHMSEmail(oid,Company,Customer, Scale)
select :oid, "Scale"."Company", Scale.Customer, scale.Oid
from inserted, Scale, Company, Customer
where inserted.Scale = scale.Oid
and Company.Oid = scale.Company
and Customer.oid = scale.Customer;
end;
end;

...

On 2/21/2018 12:58 PM, Brian Wheatley wrote:

You'd need to ask the Firebird people that. InterBase and Firebird are not the
same thing anymore and haven't been for years. InterBase does not have such a
keyword.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

On 2/22/2018 8:38 AM, Brian Wheatley wrote:

Either, InterBase does not have the ability to return values from an insert.
you have to re-query on the primary key to get things changed by a trigger.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

On 2/22/2018 4:22 PM, Brian Wheatley wrote:

You just do a select on your primary key you just inserted and get the final
values of the newly inserted record.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

On 2/23/2018 6:19 AM, Brian Wheatley wrote:

If you need to re-look up immediately, you get the generator value and pass it
as part of the insert. Triggers that fill out a primary key should always do so
only when the passed value is NULL.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)