Father? Frenchy? Frank?,

<<I am trying to write an update query and I am having problems with
the firebird syntax.

. . .

What would be the proper syntax for Firebird.>>

Here's an example:

UPDATE ORIOLES
SET FIRSTBASEMAN = :FIRSTBASEMAN,
SECONDBASEMAN = :SECONDBASEMAN,
SHORTSTOP = :SHORTSTOP,
THIRDBASEMAN = :THIRDBASEMAN,
. . .
WHERE ID = :ID;

--Had to give a tip of the hat to Rafael Palmeiro, O's 1B, who is about to
become only the fourth player in history with 500 HRs and 3,000 hits
(joining Mays, Aaron, and Murray).

Clay Shannon,
Dimension 4 Software