Add records and set every nth record field to True

[MoGrace]

I am creating a tag list for printing labels and need to set a logical field to true for every 5th record in the list.

Eg, a 20 piece tag list would have the flag field set to true for records 5,10,15 and 20.

If the arbitrary nth record is set by a variable, how would I count the records in this list as it is created using a tbl.enter_begin() routine?

[Stan Mathews]

Re: Add records and set every nth record field to True

mod(variable,5) = 0 'set the logical to true, otherwise don't

[MoGrace]

Re: Add records and set every nth record field to True

Thanks Stan, this worked when I added the ELSE condition, before that every record after the 5th was set to .T.

cnt = mod(vnt,exampc)
'Tln("vnt/exampc"+str(vnt),str(cnt))
if cnt = 0 then
	r.exam_flag = .t.
else
	r.exam_flag = .f.							
end if

Output to Trace window:

vnt/exampc 1: 1
vnt/exampc 2: 2
vnt/exampc 3: 3
vnt/exampc 4: 4
vnt/exampc 5: 0
vnt/exampc 6: 1
vnt/exampc 7: 2
vnt/exampc 8: 3
vnt/exampc 9: 4
vnt/exampc 10: 0
vnt/exampc 11: 1
vnt/exampc 12: 2
vnt/exampc 13: 3
vnt/exampc 14: 4
vnt/exampc 15: 0
vnt/exampc 16: 1
vnt/exampc 17: 2
vnt/exampc 18: 3
vnt/exampc 19: 4
vnt/exampc 20: 0

[GGandhi]

Re: Add records and set every nth record field to True

if you are using table enter begin then
can you not use a variable ( i am assuming this count is not saved anywhere in the table) like num_record and set it to 0 before the tel.enter_begin() then for every record add a number to that variable before tbl.enter_end()
and if the num_record equals 5 then make that variable 0 and set the logical field to .t.
is that not possible?
the mod function is when you already have the list and you start adding the logical field afterward, i think.

[Al Buchholz]

Re: Add records and set every nth record field to True

if you are using table enter begin then
can you not use a variable ( i am assuming this count is not saved anywhere in the table) like num_record and set it to 0 before the tel.enter_begin() then for every record add a number to that variable before tbl.enter_end()
and if the num_record equals 5 then make that variable 0 and set the logical field to .t.
is that not possible?
the mod function is when you already have the list and you start adding the logical field afterward, i think.

If I'm reading this correctly, you are suggesting writing a field to the table with the mod 5 value stored in it. Otherwise what is the enter_begin/enter_end about?

If so, what happens when records are deleted and missing in the record number sequence?

So what Stan has suggested may take a little longer when the records are needed, but would provide more accurate results.

[GGandhi]

Re: Add records and set every nth record field to True

thanks al
my theory is robin is going to make a list every time from another table to print label. that is my thinking that table will be erased every time a new label creation precess takes place.
not contesting experienced people like stan or you.

is that not possible?

may be the answer is then, no.

[Al Buchholz]

Re: Add records and set every nth record field to True

thanks al
my theory is robin is going to make a list every time from another table to print label. that is my thinking that table will be erased every time a new label creation precess takes place.
not contesting experienced people like stan or you.

may be the answer is then, no.

Yes that can work too. I think that's what they are doing. But writing a .t./.f. instead of the mod 5 value.

It helps if I reread the first post... my mistake. Thanks for your patience.

[Al Buchholz]

Re: Add records and set every nth record field to True

after additional thought the method to handle this depends on weather it's a multi user process to print labels.

For single user, you can easily build a table/list, for multi user a query wold work better.

[MoGrace]

Re: Add records and set every nth record field to True

These records in the tag list remain until goods are shipped. The exam flag I am setting is printed on the label for quality control to check those rolls (of fabric) after they have been produced. When rolls are selected for shipping they become the line item records for the packing slip, and the tag records are marked and can be deleted later. Sometimes these goods remain in stock for a while and so the tags may still be needed in case some rolls get replaced at the time the goods are actually shipped and the packing slip is adjusted accordingly. If a line item is replaced, the routine must delete that record and unmark the original tag record so it can be selected again for a different lot.

Although I have considered deleting the tag when it becomes a line item and recreating it if needs to be returned to stock.
I am curious how others do it...

[Al Buchholz]

Re: Add records and set every nth record field to True

These records in the tag list remain until goods are shipped. The exam flag I am setting is printed on the label for quality control to check those rolls (of fabric) after they have been produced. When rolls are selected for shipping they become the line item records for the packing slip, and the tag records are marked and can be deleted later. Sometimes these goods remain in stock for a while and so the tags may still be needed in case some rolls get replaced at the time the goods are actually shipped and the packing slip is adjusted accordingly. If a line item is replaced, the routine must delete that record and unmark the original tag record so it can be selected again for a different lot.

Although I have considered deleting the tag when it becomes a line item and recreating it if needs to be returned to stock.
I am curious how others do it...

Sounds like a lot like inventory lot control without serial numbers.

I like to track everything as a transaction and have a record that shows current status and another table with the transactions that support it and show the history of who what why where and how.

But that is pretty generalized. Sounds like a job for google research for Best Practices kind of documentation.

[MoGrace]

Re: Add records and set every nth record field to True

Almost every table I have includes a serialized number as the primary key. I use a transaction table to record inventory in/out movements. But I don't record each of the rolls as transactions, only the lot when created. Same as when yarn boxes are received I don't record each box but the net wt of the shipment. Thus my history reports on the related forms that are utilized in production: Bill of Lading (IN); Sales Order (OUT - Loss Allowance); Packing Slip (OUT - summary of rolls). Other transactions like Allocations for yarn put in production and goods In Stock are posted to the Yarn Item.

Best practices would be great if I could find one that concerns a knitting mill. Regular inventory procedures don't apply because they mostly concern inventory that is purchased. My inventory tracking is of the customer's yarn as it moves thru the production process.

[Al Buchholz]

Re: Add records and set every nth record field to True

These records in the tag list remain until goods are shipped. The exam flag I am setting is printed on the label for quality control to check those rolls (of fabric) after they have been produced. When rolls are selected for shipping they become the line item records for the packing slip, and the tag records are marked and can be deleted later. Sometimes these goods remain in stock for a while and so the tags may still be needed in case some rolls get replaced at the time the goods are actually shipped and the packing slip is adjusted accordingly. If a line item is replaced, the routine must delete that record and unmark the original tag record so it can be selected again for a different lot.

Although I have considered deleting the tag when it becomes a line item and recreating it if needs to be returned to stock.
I am curious how others do it...

After additional thought, what about having an index with a filter for the condition you want the entry to be on the list?

If you change the value to anything other than the filtered value the item falls off the list.