Assign a DATA in Db to barcode in excel

Create a multi-dimensional array using a UDT where the traceability UDT data record might look something like this:

TraceRecord_UDT:
  barcode : String[8];
  weight  : Real;

Then in a global DB, maybe named "TraceData_DB", create an array[0..maxRecords] of TraceRecord_UDT

TraceData_DB:
  MaxRecords : Integer = 999 // Actual Max Records = 1000 since 0 counts
  Records : Array[0..MaxRecords] of TraceRecord_UDT

Then you can assign values like this:

"TraceData_DB".Records[0].barcode := '20231OCT';
"TraceData_DB".Records[0].weight := 2.34;

You will want to convert the barcode char array to string (using the appropriate char to string instruction).

Sai Teja

Hello sir,

Did you found the way for this ,I need the same concept 

Through scanners and barcode to assign data to that particular address in db that i received string from barcode

I'm not a experienced guy I'm just 2.5 years of experience

I'm just familiar in LADDER

I'm not aware of those look up tables also......

My concept is I have a barcodes I enter in serial format like

20231OCT

20232OCT

20233OCT....so on

But when I scan I don't get product in same order 

Those products will get jumbled ......like scanner could read

Like

20232OCT

20231OCT

20233OCT

As not in order 

After receiving particular data(20231OCT) from Barcode i need to assign a DATA in Db to that barcode in excel ,Like I need to add weight parameter to that barcode.

Like wise I have many parameter(8) to 1 particular barcode....

Can anyone help me or give me idea in this......pls.....

------------------------------------------------------------------------------------------
Split from Searching a DB.