Check if a line exists

How about

IF NOT TableRec.GET(PrimaryKeyValues) THEN 
  TableRec.INIT;
  TableRec. ... := ...;
  TableRec.INSERT;
END;

?

My favorite:

IF Rec.INSERT THEN;

Savatage wrote:

How do plan on handling it when it does exist?
Do you want to modify or skip or do something else?
If it already exists how are going to insert it, you will get an error.
How about
If NOT Insert then...

I agree with Harry, there are a ton of different ways to do this. YOu need to work out though the business logic of what you are trying to achieve, THEN start thinking of the best code to solve it.

You have asked what's the best way to get form A to B, but we have no idea where A and B are, A might be your kitchen, and B your bedroom, or A might be the Moon and B might be Mars.