Check if a line exists

sbilly

Hi all,
How can I verify if a line exists within a table before inserting it?

GRIZZLY

How about

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

?

Luc_VanDyck

Don't forget the BEGIN-statement in your example!

DenSter

My favorite:

IF Rec.INSERT THEN;

Savatage

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...

David_Singleton

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.

sbilly

GRIZZLY wrote:

How about

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

?

It helped me !! Tahnks for all