I have an integer variable "VAR_PVERSION_ID" that I want to pass to an
insert query so that the column "PVERSION_ID" can receive it at the
same time as all the other columns are inserted. But I can't figure
out the syntax. Nothing I try works. Here is the basic insert query:

INSERT INTO LOC(
/*ID, PK*/
PVERSION_ID,
NAME,
FLOORAREA,
LOCKD,
CREATED,
DESLOCREF,
LOCQTY)
VALUES (
/*:ID,*/
:PVERSION_ID,
:NAME,
:FLOORAREA,
:LOCKD,
:CREATED,
:DESLOCREF,
:LOCQTY)

I have read that perhaps I should use the OnNewRecord event to do
this. Can anyone please help me with the syntax for doing this?

Many thanks,

Mitch