Find Record in table

(0) Share

Report

Posted on by JacoBosch

Hi,

I'm want to check if record/get a record from the Purchase Lines table via the Document number.

The SQL table shows these 2 records on the Purchase Lines:

I want to find the record with Document Number form the Purchase Line: PCT00049

But it can't find the record..

Not sure if this has something to do with the trigger that is created as a page extension on the Commodity Receipt screen, where the Document number is linked with the action of the trigger

Commodity Receipt Header

Kind Regards
Jaco

All responses (3)

Answers (1)

Suggested answer

Amit Baru 3,029 on at

Like (1)

Report

RE: Find Record in table

hi,

Welcome

Pls verify the answered. if useful.
JacoBosch 55 on at

Like (0)

Report

RE: Find Record in table

Hi Amit, thanks

Got it

It is getting this record:
Verified answer

Amit Baru 3,029 on at

Like (0)

Report

RE: Find Record in table

Hi,

Rec.Setrange("Document No.",'PCT00049');

if Rec.FindFirst then begin

Message(Format(Rec.RecordID.getRecord()))

Message('Order Found');

end;

Regards

Amit Sharma

www.erpconsultors.com

press yes if info is useful.